Hi

If you use dynamic properties task and use either global variable or ini files then you can use it on as many databases you like if the structure of...

Hi,

In execute sql task either you need to make a query or execute stored procedures. In both cases you can use global variables for parameters. like in a sql query...

Hi,

To insert conditional logic you need to add an active x script.

Hope this helps

Urvashi

Hi,

not very clear with the question

. do you want to migrate the access database to a sql server database.

If yes then you can copy all the data in access...

Hi

Try running this command

Regsvr32 c:\winnt\system32\msexcl40.dll

Not very sure whether this will help you out or not but can still give it a try.

Regards

Urvashi

hi

http://www.databasejournal.com/features/mssql/article.php/3073161

hope this helps about how to use ini file

Regards

Urvashi

Since the structure of the three tables are different so you will need three different tasks and why do you want to store the table names in a separate table ,...

I dont understand why u need 10 different connection , why can u not use the same connection for every data driven query???

and i am not clear with your question...

You need to set the autogenerate for that column of target table to true and then every time when you will add data to this table it will automatically create...

Normally you can fix this by simply re-registering the DTS ActiveX Script Host DLL (axscphst.dll), using the Regsvr32.exe utility.

Regsvr32.exe "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll"

Hope this works

Urvashi

Hi,

You have to create a dynamic properties task in which you need to go Tasks and select the task for which you need source table name.....

select the source object name and...

In the DTS Task(Assuming that you have a task of type Transform Data Task)in which you are importing the data to temp_ prefixed tables(through Active X Script) all you need to do is...

If you have the condition to skip rows then this should work:

If <<condition>> Then

        Main = DTSTransformStat_SkipInsert

Else

       DTSDestination("....") = DTSSource("......")

       ....................

        Main = DTSTransformStat_OK

End If

Hope this helps