do you get any error messages?

One thing I ran across is an OLE DB connection to DB2 returning incorrect row counts. I use all ODBC connections for DB2 and...

Thanks, our net admin called me asking why our ssis server is sending these requests. He also said they were being blocked that is why he noticed them.

Here is an example of a project developed by microsoft and other companies. It comes with everything you need, databases project files, etc...

You can also use this as a...

You can't reference a variable in an exec sql task like that.

Depending on your data source (not all providers support parameters) you will need to code it like:

SQL OLE DB...

I have a couple questions. There does not appear to be any definitive answer anywhere on this topic of Temp Buffer Storage. Currently I have data flows that are writing...

Never mind.

Apparently when you don't sort your query you can't expect the results to always come back in the same order.

All the records I was missing were at the bottom...

Update:

The reason I couldn't use the temp tables is because I needed to update the table.

What I did is created a temp table for the right side of the join...

That is strange. All package level variables should be visible everywhere. Don't know what you've tried up to this point but I'm guessing there may be some corruption. If you...

That sounds like a space issue. If it was able to create the file then it should be able to grow it.

Wish I had a better idea, never came across...

After some more looking i have the SVN keyword substitution working. Quite simple in fact. On the working directory right click on the folder that contains all the DTSX files...

Matt you mentioned using the keyword sub and update the revision comments.

From what I read SVN simply searches the document looking for a text string such as $Rev$ and then...

In addition the called packages didn't fail since there never was a password to decrypt. Had there been package passwords set for the child packages within the Execute Package Task...

I have a resolution on this topic. The problem was not with the packages being called, it was the calling package that that had save sensitive with user key. It...

rahulsony111 (1/13/2010)

---

When you say you added the column in the OLE Source I'm guessing its coming from SQL Server column of type varchar

Yes it is coming from SQL SERVER as...

rahulsony111 (1/13/2010)

---

I have a data flow in a package where source is from SQL SERVER and target is ORACLE.

My task is to add a column for that data flow called...