Viewing 15 posts - 1 through 15 (of 62 total)
Creating useful stuff, programs and databases that actually help people do their job, not just pretty stuff.
January 11, 2006 at 10:17 am
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...
September 27, 2005 at 2:42 pm
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...
September 22, 2005 at 10:40 pm
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...
September 22, 2005 at 9:38 pm
Well, select convert(varchar(10),getdate(),101) returns this
which is different than
if we are talking about charater data. You will have to strip off the leading zero.
July 22, 2005 at 11:50 am
There are many different ways to make a package portable. Here is one:
I've used ActiveX tasks to set Server and Database Connection information based on Dev, QA,...
July 21, 2005 at 10:55 am
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...
July 20, 2005 at 3:49 pm
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,...
July 20, 2005 at 3:22 pm
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
July 20, 2005 at 3:12 pm
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.
July 20, 2005 at 2:05 pm
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:
You can also...
July 20, 2005 at 10:29 am
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...
July 18, 2005 at 9:48 am
Using DTS would be MUCH simpler than writing SQL scripts using OPENROWSET...do yourself a favor and look into it.
July 17, 2005 at 11:39 pm
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.
July 13, 2005 at 11:08 am
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...
July 12, 2005 at 4:15 pm