For my data transfers from our AS400 I have set up a Linked Server that uses the iSeries Access ODBC driver. Then I use TSQL syntax in my SSIS...

Yes, as Jack said, you may want to go the other direction and have the report subscription fire the SSIS package. From BOL: http://msdn.microsoft.com/en-us/library/ms345250(SQL.90).aspx

There is an example of...

Here is a small vbscript I use to login to a site and click a button on a subsequent form. I run it from a scheduled task, not from...

I used the pivoted ID columns to join on and to group on. I did not have to concatenate the ID's. There was additional analysis to be done,...

Bob Hovious (3/6/2009)

---

This is what I was keying on. But your point is well taken, Jeff....

noeld,

Thank you, I think that your pivot script gives me what I need. I never used the row_number over partition functions available in SQL 2005. Since I can...

Jeff Moden (3/5/2009)

---

I've gotta ask, Ed... why do you need this type of denormalize output? What is that output going to be used on? I'm asking because I...

Another option would be to execute the SSIS package from a SQL Agent job if your server-client is capable of executing sp_start_job.

I don't know if this matters...

but you might try losing the User:: and just use the variable name

also if there is a space after the comma that might be a...

Is your variable declared in the ReadVariables property of the script dialog?

Also, the Derived Column transform is probably a bit easier to use if all you are doing is adding...

Well... I've learned something here. You can't really disable a task at runtime. What you can do is put an expression in the workflow precedence (the arrow) to...

Here are example values for the FileSystem task:

UseDirectoryIfExists = True

Operation = CreateDirectory

IsSourcePathVariable = True

SourceVariable = User::DirToCreate

For your script dialog:

ReadWriteVariables = FolderExists

As G squared indicated, there is a UseDirectoryIfExists property you can set to True in the FileSystem Task. As to why your code isn't working - two things you...

I think you are experiencing the "double hop" issue with Windows Authentication (you can Google that for more details). Basically, Unless you have Kerberos enabled for these servers, you...

Not sure what you are linking into, but I have a similar issue with my DB2 Linked Server. Management Studio will come back with the table names, but it...