|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Parametric DTS Posted by Leila at 11/30/2005 11:13:26 PM Hi,
How can I execute a DTS Package and send parameters to it .
The execution must be performed via TSQL commands, not from a client app
(e.g from a job).
Thanks in advance,
Leila
...more >>
CreateParameter - Passing a parameter to a stored procedure in a DTS package Posted by brendan_gallagher_2001 NO[at]SPAM yahoo.co.uk at 11/30/2005 12:58:53 PM Hi,
Thanks for your replies. I have a query related to passing parameter
to a stored procedure in a DTS package. The code below is whatI am
using. Basically, the code does not seem to be picking up the
'EndDate' parameter that I am passing to the 'usp_PaymentExt' SP.
Could someone please h...more >>
DTS Packages in SQL Server 2000 (Windows 2000 vs. Windows 2003) Posted by guidry49 at 11/30/2005 12:12:04 PM We have a database server (DWPROD) running Windows 2000 with SQL Server
2000(sp3) and mdac 2.7 sp1 refresh. We are migrating to a new database
server (DWSQL) with Windows 2003, SLQ Server 2000 (sp3) and mdac 2.8.
I have been unable to open dts packages (either structured storage files or
l...more >>
Adding a DTS package Posted by John at 11/30/2005 9:37:28 AM Can a DTS package be added to a server via the command line using OSQL?
Thanks in advance
John...more >>
Using my own dll in script task Posted by Nightcrawler at 11/30/2005 8:58:16 AM Is it possible to write and compile my own class libray in c#, compile
it and then reference it in a script task in SSIS? How would I go ahead
and do this?
Thanks
...more >>
problem creating DTS package Posted by Mohan at 11/30/2005 7:42:25 AM Hi,
I am trying to create a DTS package wherein the data from the sql
server is transfered to a text file. I am using the Transform Data Task
to transfer the data.In Transform Data task properties, I build the
query and able to preview the data but when i click OK in the Transform
Data ...more >>
SSIS 2005: help with "derived column" expression syntax Posted by frostbb at 11/29/2005 5:22:03 PM I'm loading data from a flat file into an Sql Server table ... using "Flat
File Source" and "OleDb Destination" controls.
In between I'm using a number of derived column controls to add and
transform data from the flat file.
I need to derive a payment_type value depending on the contents o...more >>
DTS LoadFromSQLServer permissions Posted by brendan_gallagher_2001 NO[at]SPAM yahoo.co.uk at 11/29/2005 2:23:55 PM Hi,
I have a ASP (classic) wepage the running a SQL Server 2000 DTS package
which creates a text file and drops it in a specified network folder.
I need to know which user needs to be given write permissions on this
folder so that they can drop the file in the folder once the DTS
package is e...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Scheduling non-SQL Server job after DTS completes Posted by Mike Austin at 11/29/2005 12:20:02 PM I have a DTS/ETL package that is running perfectly. The data from the data
marts is currently imported into SAS/SPSS for cleaning and weighting. The
SAS/SPSS jobs are kicked off manually. I want to be able to schedule these
SAS/SPSS jobs so that they automatically execute after the DTS package...more >>
Validate columns in a text file before import Posted by Nightcrawler at 11/29/2005 7:24:26 AM Hi,
I have an SSIS ackage that I have setup to import multiple flat file
sources. Each flat file source is different since the number of columns
and formatting (tab or comma) vary from file source to file source.
Now, in a perfect world this would work assuming a file is always true
to its ...more >>
DTS Text file export Enterprise Manager crash Posted by gilbertcj NO[at]SPAM gmail.com at 11/29/2005 3:59:15 AM I have a problem using DTS (SQL Server 2000) to export to a text file.
If I try to create the DTS using the designer if I am exporting from a
table with more than 16 columns when I come to define the columns in
the text file Enterprise Manager consistantly crashes.
The steps to reproduce are a...more >>
Dynamic Properties task and sql execute task Posted by Hans - DiaGraphIT - at 11/29/2005 1:23:04 AM Hi!
this is my case. I have an ini-file containing info about server location,
password and database name. My "dynamic properties task" reads from the
ini-file and the specified values. My next step is a SQL Execute task where
I want to create a database based on the name from the ini-fi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |