Ok, this will probably be easy for you guys, but this is my first time to do a DTS package. I setup my package and now when I go to set it up to run on a schedule, I get the following error.
Package Error
Microsoft SQL-DMO(ODBC SQLState: 42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The specified @name ('FLEXSERV 002') already exists.
I don't understand how it can already exist if I have not set it up yet. I did create this and then delete it and re-set it up, could this be the problem?
*confused*
Package Error
Microsoft SQL-DMO(ODBC SQLState: 42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]The specified @name ('FLEXSERV 002') already exists.
I don't understand how it can already exist if I have not set it up yet. I did create this and then delete it and re-set it up, could this be the problem?
*confused*