Documents and settings, your default directory, My documents, Visual Studio 2005, Projects, . Files with dtsx extensions.

During testing time or after deploy?

Please read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

It is hard to explain in one forum post reply. Please read the book "Microsoft SQL Server Integration Service step by step".

What you mean saying "Data Variable"?

To add variable to package right click on Control Flow tab surface and select Variables.. menu option.

What you are try to do using ForEach...

I think you must first migrate your DTS 2000 package to BIDS, convert in to SSIS package and next read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

You are asking on SSIS forum so use Excel Source component from Data Flow task ad redirect data from it to any available destination (table, flat file, excel and so...

Read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

It is saved on SSIS instance (one per 2005 server). So connect to it using SSMS and look at Stored Packages (look at File System or MSDB - depending where...

DB_Newbie2007 (12/13/2007)

---

I found a website today that describes variable usage, http://www.sqlis.com/81.aspx .

However, when I have three "columns" of data coming in, index 0, 1, 2, (for the...

DB_Newbie2007 (12/12/2007) b) In a Data Flow Task (not sure, but perhaps my problem is not using another Execute SQL Task?), run the following query:

select * from...

Read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

May be this can help you.

Try to add derived column component between source and destination and explicitly define data types (and length for string) for each column on the destination side.

Please explain "step by step" what you want to this SSIS package do.

Use script component (transformation type) to create this table "on the fly". Only one task for this component will be executing SqlCommand which creates this table. Output path from this...