DTS and PKs/FKs

Hey guys, i have a db on my home dev server and When I used DTS to upload everything to the prod server, I noticed many FKs did not go thru. Some did, some didn't. I have about 77 tables a few with more than 5 FKs. Is there a reason for this? What's going on? Only thing I can think of, and I don't know much of the DTS internal process, is when the DTS was being performed and a table is created maybe the FK would not pass if the other table was not created? Does DTS create all the tables first, then performs the FKs or what? Any help will be grateful.

Thanks.Nevermind, i just found out that they ARE there. They just didn't show in EM until I opened the PK Table. then it showed in the FK table. Thanks.

DTS - Execute Data-pump Task

SQL 2K
Using Active X script , created the source SQL statement for data-pump task
and it worked.
Inside Active X script I am looping thru to change the source SQL
statements, how can I again execute this data-pump task.
When I look the source SQL in data-pump task it got changed , but data-pump
task executed only once.
So my question is, how to execute a data-pump task inside Active-X script '
Thx
DUWhat are you using to determine your new connections ?
Why do you need to reset this during the package?
You can easily loop to do this but you have to loop on something.
How are you calling the package ?
Looping, Importing and Archiving
(http://www.sqldts.com/Default.aspx?246)
How to loop through a global variable Rowset
(http://www.sqldts.com/Default.aspx?298)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"MS User" <sqlman@.sql.com> wrote in message
news:%233nQmIbnDHA.744@.tk2msftngp13.phx.gbl...
> SQL 2K
> Using Active X script , created the source SQL statement for data-pump
task
> and it worked.
> Inside Active X script I am looping thru to change the source SQL
> statements, how can I again execute this data-pump task.
> When I look the source SQL in data-pump task it got changed , but
data-pump
> task executed only once.
> So my question is, how to execute a data-pump task inside Active-X script
'
> Thx
> DU
>

DTExecUI - Package Execution Utility Error

Hi,

when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error.

The Product Levelis insufficient for component "Flat File Source(1)"

the package design is

FlatFileSource -> OlEDBDestination

what could be the solution for this?

Thanks

Jegan

You need to install SSIS on this machine.
Most likely you've installed Workstation Components, but to run packages outside of designer environment you need to install SSIS (separate checkbox on one of first setup pages).|||Thanks Michael

DTExecUI - Package Execution Utility Error

Hi,

when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error.

The Product Levelis insufficient for component "Flat File Source(1)"

the package design is

FlatFileSource -> OlEDBDestination

what could be the solution for this?

Thanks

Jegan

You need to install SSIS on this machine.
Most likely you've installed Workstation Components, but to run packages outside of designer environment you need to install SSIS (separate checkbox on one of first setup pages).|||Thanks Michael