|
|
|
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 Simultaneous processing in DTS Posted by Webtechie at 8/7/2007 10:32:02 AM Hello,
I have about 55 clients for which I need to process data. There will be as
many as 5 steps to move data from one database to the other, transform the
data and then final processing of the data.
Question 1:
Can I execute multiple SQL Tasks at the same time? I would need to start...more >>
DTS issue on SQL 2k Posted by clrevill NO[at]SPAM hotmail.com at 8/7/2007 10:23:33 AM I am getting the following error when I try to run the DTS package
that was is to be run as a scheduled job:
DTSStep_DTSActiveScriptTask_2 DTSRun OnError:
DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: Error Code: 0 Error Source= Microsoft VBScript
runtime e...more >>
ssis configuration package Posted by farshad at 8/7/2007 3:14:22 AM The idea is to make the connectionstring property of the oledb connection
dynamic (Which is in connection manager).
Using the wizard, created a package configuration file called
Configurations.dtsConfig
Opened it in notepad and placed the connectionstring inside
<ConfiguredValue></Config...more >>
dynamic connection Posted by farshad at 8/7/2007 1:38:39 AM Hi,
SSIS packages are now created and tested against dev sql server.
Now I would like them all to point to the live sql server.
What is the best way to have the connection dynamic?
Obviously I prefer not to go through each package and change the connection
manager.
Thanks...more >>
SSIS pulling data from Excel 2007 Posted by bmwbase-newsgroup NO[at]SPAM yahoo.com at 8/5/2007 10:51:18 PM is it possible to import data from Excel 2007 (.xlsx files) into SQL
Server from SSIS? The Excel Source only gives up Excel 97-2005 (plus
the old versions 3/4/5)
...more >>
Real challenge for DTS and Gurus Posted by klninc at 8/3/2007 2:58:04 PM MS and DB gurus,
I have this scenario.
Source of Data:
Paradox Data using ODBC / Paradox Drivers
I need to send DYNAMICALLY built Queries to Paradox and grab the data. Save
the data to the SQL Server table. The dynamic query building will happen in
the Web Front end using ASP.net page...more >>
loss of permissions Posted by bic at 8/2/2007 3:24:03 PM Hi,
How do I prevent permission wiped from my SPs when it comes to restoring
dbs? Is there a way to assign permission globally? Thanks.
--
bic...more >>
location of DTSX packages, msdb or file system? Posted by Panos Stavroulis. at 8/2/2007 4:02:03 AM Hi,
does anyone have an opinion as to where packages should be saved? I am using
the file system at the moment but I've read that it's more secure and
reliable if saved in msdb. I don't have a problem with the file system but we
have a problem with Doubletake (software for DR) and I am hopi...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Urgent...Permission problem of DTS schedule Posted by ºa¤Ö at 8/2/2007 12:00:00 AM Dear all experts,
I have googling already, but still cannot found out the solution.
I have packed a DTS, which will read Excel from a domain server, and set the
schedule, if I running the DTS manually through the Enterprise Manager, I
can run successfully. However, the scheduled work is fa...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |