Viewing 15 posts - 61 through 75 (of 101 total)
yes that is true although it will only try and you still need multiple connections as only one connection object can be used at a time(so with one connection object...
August 21, 2003 at 7:08 am
Are you doing a Transformation task at all or just a sql query. Where does a,b,c,x,y,z values come from to be inserted. If it is a data transformation you can...
August 21, 2003 at 4:05 am
Try creating a normal table in the database your connection for the sp is running. drop the table after use as mentioned above. this should work. You may want to...
August 20, 2003 at 5:17 am
If you edit the dts package and add an ftp task to it you can always ftp the file.
August 20, 2003 at 5:11 am
try doing an activex transformation on the columns
set
DTSDestination("DestinationColumn") = CCur(DTSSource("SourceColumn"))
August 20, 2003 at 4:32 am
Start with an axtivex script to genterate the filename for the day
eg filename = "ex" + date + ".xls"
Yor next step will be an FTP Task where the source...
August 20, 2003 at 4:10 am
Why cant you create an ftp step to run and copy the file before the transformation step.
Another way would be to have an activex script and use the Filesystem...
August 20, 2003 at 3:16 am
Never knew about the escape character always used Square brackets. Well we learn something everyday.
if i understand the use of the escape character correctly ,then there are two correct answers...
August 18, 2003 at 3:51 am
try in activex script
DTSGlobalVariables("PackageName") = DTSGlobalVariables.parent.name
But DTSGlobalVariables.parent.name will give you the package name in any part of the package without setting a global variable.
August 15, 2003 at 9:22 am
In your Transformation Tak what lookups are you trying to do. If you do not intend to do a lookup you may have something bogus typed in their hence...
August 15, 2003 at 9:14 am
I do something similar.1 step Select The filename as a string and then save the datepart to a global variable.2nd step trasformation do an activeX for the column
as
DTSDestination("DateTime") =...
August 15, 2003 at 5:34 am
I am Confused. The stament the colums should contain is 'chicken AND NOT soup' The AND NOT are not operators but just words to look for in the colums i.e...
August 12, 2003 at 3:43 am
I thought it would return all five rows because they all contain Chicken,Soup.Why is the answer 4 rows and why will the "Soup a la Chicken"-"Soup made from chicken." recipe...
August 12, 2003 at 2:48 am
quote:
Although I chose the "correct" answer, the correct answer to the question should have been "You can't run Enterprise Edition of SQL...
July 30, 2003 at 9:14 am
Very good!!
You forgot the HR director
Mr Pay_Peanuts_Get_Monkeys
July 30, 2003 at 4:17 am
Viewing 15 posts - 61 through 75 (of 101 total)