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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|