Thanks Dan. Its really helpful !!! 🙂

You just need to create separate configuration files for all the environment (dev, qa, test, prod). Change the variables and...

quillis131 (4/11/2011)

---

Loading data from flat file to Sql table. I have a column X in table that needs to be updated with time stamp ( this column cannot be...

Great!!!

I completely miss the concept of BIT and make it wrong ... :hehe:

MyDoggieJessie

UPDATE _ReadyTables

SET Loaded = 1

WHERE [Table] = ?

AND ETLDate = (

SELECT ETLDate FROM dbo._ReadyTables

WHERE [Table] = ? AND Loaded = 0 )

I created a variable:

Variable Name: User::FL_PRICE

Direction: INPUT

Data...

Walter Tucholski (3/9/2006)

---

I am using SSIS 2005 and have variables defined at the package level. When I try to execute a query in an Execute SQL Task it doesn't recognize...

Hey,

In your case you are missing single quotes ('). Your query should be written inside Var_ZZ's expression property like this.

"select A, B, C, D,ADDED_DATE, CLIENT_TYPE from Table1

where CLIENT_TYPE <>...

Hey,

What is the error that you are getting?

You can also pass parameter in your OLEDB source adapter. Select Data Access mode as 'SQL Command' then write your query like...

I dont think update statement will work like the way you wanted it to as rows are duplicated & it will update the record with 1st occurrence every time you...

Hey rocky,

What is the need to create child...

This might help you-

http://www.databasejournal.com/features/mssql/article.php/3646531/SQL-Server-2005-Integration-Services---Part-38---Pivot-Transformation.htm 😎

copett86 (4/4/2011)

---

I have a DataReader Source using ODBC driver(ADO.NET) for a connection that links to an outbound flat file destination. I use to have a data conversion step, but took...

Hi,

Actually this can be achieved through number of ways. But what I was thinking will work best when you could create a tracker table in you DB.

Something like this will...

Hi lrutkowski

The way you are writing the script will work fine with SSIS 2008, though in your case i would rather suggest to use Script Task. You can update...

Andrew Williams (3/10/2011)

---

Ok so from the postings:

loop through the tables doing:

1. Script task to create dynamic sql to create the table if it doesn't exist on destination.

2. Run sql against...