Save your package as a Visual Basic File and open it and look at the code that was generated. This will give you the syntax you can use in an...

Have you checked the permissions that SQLServerAgent is running under? If the code runs fine under your user name but not as a job then you probably need to adjust...

Search Books OnLine, set the active subset to Data Transformation Services, search for Object Model, and look at the article entitled Configuring Properties for DTS Transactions. From there you can...

The best book I have found so far is Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step

-- Olap Train (Editor), Reed Jacobson. Unfortunately, there just doesn't seem to...

It would be possible to do this with an ActiveX script and two recordsets. However, you should look in Books OnLine (in SQL Server online documentation) for Data Shaping...you can...

In the second sql task, the one in question, are you assigning the variable as an input variable? if so, then I do not have a clue off the top...

In your package, you need to create a global variable. Then on the execute sql task, click on the global variables (parameters?) button and there you can assign the value...

Obviously, the files have to change name according to some set logic in order to program a dynamic file selection. Or the files have to have a naming pattern so...

Look back in the DTS forum here for the posting entitled Changing the Source File in DTS. I have code posted there that will do exactly what you need although...

Sorry for the long delay in responding! I hope you have gotten an answer or figured out a solution long before now. As far as i know, there is no...

Check the permissions for the account that SQL Server Agent is running under. My guess is that your script is running fine under your account when you run it from...

You can specify where Analysis Services stores the files by setting the data folder. Also, you can specify where the temp data folder is located too and you want to...

Andrea,

If you look at the query example I posted, I think you will see that it is almost exactly what you need...and can be modified to do what you need...

Andrea,

This is the query example I was speaking of...basically, it adds records to a table (cust_loc) that links a customers table to a customer_location table (many to many). It only...

I guess I am lost here, Andrea...if you join your tables with foreign key constraints then the primary keys will by definition be synchronized with the foreign keys...perhaps a breakdown...