Creating useful stuff, programs and databases that actually help people do their job, not just pretty stuff. 

Diane

I think the poor author is totally embarrassed by all of this feedback and is now hiding under a rock somewhere…I feel a bit sorry...

Oh yes, I'm glad I took the job. The senior DBA's were great at teaching me although I did give them some grief from time to time. Like...

Actually, I started my IT career as a junior DBA (this was in 1999, before the dot com meltdown). I was working for a large private company in Minnesota...

Well, select convert(varchar(10),getdate(),101) returns this

07/22/2005

which is different than

7/22/2005

if we are talking about charater data.  You will have to strip off the leading zero.

Diane

There are many different ways to make a package portable.  Here is one:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=99&messageid=8511

And another:

http://sqlservercentral.com/cs/blogs/phil_cart/archive/2005/07/19/59.aspx

I've used ActiveX tasks to set Server and Database Connection information based on Dev, QA,...

Jason,

The answer to 3 is depended on the answer to 3.  You can use either an ActiveX task or the Dynamic Properties Task.  Let me show you some code for...

If are creating it through the wizard or the data pump task, yes that is normal behavior.  If you want to copy a table with the PK and Identity properties,...

Example:

dtsrun /E /S ServerName /N NameOfPackage /A FirstVariable:8=Value /A SecondVariable:8=Value /A ThirdVariable:8=Value

The /E is for a trusted connection

And they are case sensitive!

Hope this helps

Diane 

Jason,

Yes, the ActiveX/Dynamic Properties task comes first in the DTS workflow so that it will change the text connection properties before you connect to the file and import the data.

Diane

Answers to your questions:

1.  You can use VBScript within a ActiveX Task to change the name of the file you want to import.  Check this article out:

http://www.sqldts.com/default.aspx?200

You can also...

In the MSDB database their are several tables that hold information about the SQL Agent jobs.  One is named sysjobhistory.  Look in that table to see if their is any...

Using DTS would be MUCH simpler than writing SQL scripts using OPENROWSET...do yourself a favor and look into it. 

Diane

You also could put your generic function in a seperate package and then use the Execute package task from any other package to call it. 

Diane

Instead of trying to convert the data from a string to a Date/Integer datatype during the import, you could import the file into a table with all text fields (including...