Any ideas would be greatly appreciated.

Thank you.

From the Data Warehouse Toolkit Second Edition Ralph Kimball, Margy Ross page 98:

It certainly would feel natural to include an effective date stamp on a dimension

row with type 2 changes....

I created an environmental variable and a package configuration and it gave me an error when I loaded it.

It said that the package was corrupt and I saw three errors,...

Thanks Andy.

Could someone please provide me with a script for a Database and Table to Store the Package Configurations?

Thanks.

ok, I'm sorry about the poor post.:blush:

I had to come up with aliases because the information is confidential but you have given me ideas to present you with what...

I just need to add a subquery where SequenceNumbe IN MAX(SequenceNumber) and do the groupping.

I was coming back to my desk with a cup of coffee and all of a sudden the light bulb went on.

It was...

Issue has been resolved.

It was a permissions issue on the Account used for the SQL Server Agent.

For the task that I had to use Stored Procedures with OpenQuery Statements it...

It was a permissions issue on the Account used for the SQL Server Agent.

For the task that I had to use Stored Procedures with OpenQuery Statements it worked.

The majority of...

If I execute the SSIS Packages using the DTExec as a CmdExec it does not load any transformation task.

If I run DTExec from the command line it works.

It only populates...

opc.three (3/26/2012)

---

I use File System packages and execute them using DTExec from a CmdExec SQL Agent Step Type, not an SSIS Step Type.

I use XML Package Configuration files (.dtsConfig) for...

Please do not respond to this post for I have restated the question at the following post:

http://www.sqlservercentral.com/Forums/Topic1274990-1550-1.aspx

Lynn Pettis (3/28/2012)

---

Going out on a limb here, I don't think so. From BOL:

The Integration Services service is not required if you only want to design and execute Integration...

Could it have something to do with SQL Server Integrated Services 10.0 failing to start?

The Tables in which I'm populating from a transformation task (AS400 Source) are not populating.

The...