There are plenty of scripts available to check for foreign key constraints and disable them, truncate then re-enable them. Also you should be aware of the difference between the...

In my case I started to really learn sql on my current job, even the previous job I had was sql development for a year, this job exposed me to...

I would use the a script transformation task inside a data flow task.

I have used this before for files that have different records types/number of columns in them.

Takes a little...

I would transfer the data using the Unicode data type (NVARCHAR)

Try something like this, replacing the query:

DECLARE @tableHTML NVARCHAR(MAX) ;

DECLARE @sqlquery VARCHAR(MAX)

SET @tableHTML =

N'<H1>PLACE TABLE HEADER HERE</H1>' +

N'<table border="1">'...

You can import into the NVARCHAR datatype from excel or use data conversion task is ssis

I don't understand why someone would get annoyed by a forum post asking for interview questions, sounds like there are quite a few people that are kinda snobby in these...

Seems like this article is like old news, not only do I see this mentioned quite often in forums when I have time to check questions, but now its yet...

Here is a batch file to execute ssis packages:

the /DECRPYT is where you would put the package password (if there is one)

The following illustrates using the 64 bit bit version...

I would dump the expression and use Execute SQL Task as it is easier to read and maintain.

Here is what I would do, you might need to tweak as I...

I'll take a stab at answering this...

Create a query of the data using SSMS that yields you all the data you need to extract.

Create a Data Flow Task within SSIS

Use...

Sorry had to add my two cents about using expressions with Date included in the file name.

This is a bad idea if you will be running the package around midnight...

If you are using ssis 2008, you can set up variables read/write in a vb script task.

Easy to modify, just set-up the variables you will be reading and writing from...

Using SSIS Variables for:

Data Locations - Process and Archive folders

Server Connections (Dev/Prod) - This is kinda cool, create connection strings using the variables, then when migrating just change the variable(s)...

Here is an excellent article from 2008:

http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/64585/