Archived Months
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
all groups > sql server dts > august 2007 > threads for august 22 - 28, 2007

Filter by week: 1 2 3 4 5

dts packages cannot be scheduled
Posted by doug NO[at]SPAM seanyc.org at 8/28/2007 8:32:13 PM
My DTS package runs fine when I execute it (from Enterprise Manager) and I can open the scheduling option by right-clicking the DTS package, but it won't save the schedule I create. Any ideas?? ...more >>


Migrated DTS Packages to 2005, missing
Posted by Patrick at 8/28/2007 10:20:02 AM
I went through the Migration Wizard. Management -> Legacy -> Right click on Data Transformation Services. I just want to migrate a simple DTS package that copies objects from one database to another. When I run through the wizard, it runs successful; however when I go to Management -> Legac...more >>

Move SSIS packages to a new SQL 2005 server
Posted by FidelR at 8/28/2007 8:46:02 AM
Hi I have a problem regarding running a SSIS Package in a schedule Job (SQL server agent). I recently moved all my SQL server 2005 components (SQL server, SSIS, SSRS) to a new SQL server 2005 with service pack 2 installed. I also created a new job to run my old packages. When I’m running ...more >>

executing packages in 32bit mode
Posted by Frederik V at 8/27/2007 12:00:00 AM
Hi I'm currently experiencing the following error when running one of my packages: Error: 2007-08-27 13:52:43.91 Code: 0xC0202009 Source: ************* Connection manager "Excel Connection Manager" Description: An OLE DB error has occurred. Error code: 0x80040154. An OLE DB reco...more >>

SQL server 2005 Express Syncro data
Posted by Manekurt at 8/23/2007 10:30:50 PM
Hello to everyone. I need to synchronize data between servers, where the source is SQL Server Express 2005, and the the server is SQL Server 2000. I´m using VB.NET, and I linked the server, and then pass the information to the server, but here is my problem: TABLE CUSTOMERS ID CUSTOMER...more >>

Filter data in OLE DB Source
Posted by Daniel at 8/22/2007 8:46:01 PM
Hi, I'd like to filter data in the OLE DB Source node based on a variable value, to realize the function simliar to "SELECT * FROM Table WHERE Col1=@var1". But it appears to me that the only way I can do this is manually structure a sql statement in a Script Task node and execute it in the ...more >>

Execute SQL Task Error
Posted by Allen H. at 8/22/2007 1:16:20 PM
I'm relatively new to SSIS and am getting frustrated. I have a simple Execute SQL Task that is getting an "Invalid character value for cast specification" error. Here's the issue (all names are changed to simplify). I have a stored procedure with three parameters: dbo.someproc ( @p1 int...more >>

Similar projects (SSIS package)/suggestions.
Posted by Lam Nguyen at 8/22/2007 9:26:02 AM
I have to write a SSIS package to transfer data from production server which has about 120 databases to dev server. Each database has 160 tables and each table I only need a few columns out of it. Has anyone had done a similar project like this or know of a best way to do it. The trick for ...more >>




DevelopmentNow Blog