The world of SQL Server without SSIS

Within the scope of my new project, I need to migrate SQL Server 2000 & 2005 to 2008 R2.
Sounds a lot of fun huh?
Well check out this code, never seen something like this before though:

The code

Actually, when you break it into pieces, it’s quite simple.
It uses two procedures in SQL Server:

EXECUTE xp_cmdshell { 'command_string' } [ , no_output ]
Example: EXEC xp_cmdshell 'dir *.txt'

EXECUTE xp_fileexist { ‘filename‘ } [, file_exists INT OUTPUT]
Example: EXEC master..xp_fileexist 'c:\boot.ini'

Advertisements

One thought on “The world of SQL Server without SSIS

  1. Pingback: SSIS Import Flat Files with Headers « Clint Huijbers's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s