Hi All, Can any of you kindly point me to some URLs for templates for documenting SSIS/DTS packages and templates for documenting the database...

KarenM

02-17-2009 10:38 AM
Joe H

Hi there, I am simply trying to view an existing SSIS package that I created some time ago. The database settings have changed and I cannot seem to...

Waldy

02-16-2009 05:40 PM
tbradshaw via SQLMonster.com

Hi, When setting the Data Access Mode to Table or View, the trace in PRofiler looks something like this: SET ROWCOUNT 1 SELECT * FROM Products SET...

Ola

02-16-2009 01:55 PM
Ola

Hi All, This is verrrrrrrrrrry urgent. It will be very helpful if some one reply me ASAP. We have a SQL Server 2000 server with a database of 35GB...

Srikanth via SQLMonster.com

02-14-2009 10:30 PM
tbradshaw via SQLMonster.com

Apparently, in this version of SQL Server (as found in Small Business Server 2003 R2 Premium), there doesn't seem to be a complete solution in...

stjulian

02-13-2009 04:52 PM
tbradshaw via SQLMonster.com

Anyone know what could possibly cause this error: The return value was unknown. The process exit code was -1073741701. The step failed. The error...

Eric H.

02-13-2009 03:45 PM
Eric H.

Hello all, I am having a VERY intermittent problem that has been discussed here, but perhaps not in the context of my experience (or at least I...

greenmtnsun

02-13-2009 01:00 PM
greenmtnsun

Hello all, I am having a VERY intermittent problem that has been discussed here, but perhaps not in the context of my experience (or at least I...

greenmtnsun

02-13-2009 12:59 PM
greenmtnsun

Hi, I work with Sql Server Business Intelligence Development I import a DTS coming from SQL 2000 server and the importation work with succes Now I...

GC

02-13-2009 12:52 PM
Todd C

How to convert sql server 2008 db to sql server 2005 db ? Siva

siva

02-12-2009 11:58 PM
siva

Hi Everybody, In SQL Server 2005, I have some data in an SQL table. Now is there a way that I can automatically generate the insert scripts which...

MS Techie

02-12-2009 05:11 PM
tbradshaw via SQLMonster.com

Just wondering if there is a way to execute a DTS package from a stored procedure in SQL 2000? Thanks

Hurme

02-12-2009 10:31 AM
Hurme

I need to make a program that can read a plain text file and can generate information in a database. Required to use SQL Server 2005...

Jose Luis Cocha

02-11-2009 10:24 AM
Gerald Aichholzer

Hi, I had two jobs that ran SSIS packages on SQL Server 2005, and I had disabled both of them. Both jobs had a schedule that had them running every...

Brian Hman

02-10-2009 10:12 PM
Peter Yang

Hi Everybody, In SQL Server 2005, I have some data in an SQL table. Now is there a way that I can automatically generate the insert scripts which...

MS Techie

02-10-2009 02:31 PM
MS Techie

Hi All, In SQL Server 2005, I have some data in an SQL table. Now is there a way that I can automatically generate the insert scripts which loads...

MS Techie

02-10-2009 02:30 PM
MS Techie

Hi Everybody, In SQL Server 2005, I have some data in an SQL table. Now is there a way that I can automatically generate the insert scripts which...

MS Techie

02-10-2009 02:29 PM
MS Techie

Hi Everybody, In SQL Server 2005, I have some data in an SQL table. Now is there a way that I can automatically generate the insert scripts which...

MS Techie

02-10-2009 02:29 PM
MS Techie

I have data in a table in Oracle that I want to query tp simply find out if something is true or false. Then, I want to tell SSIS to evaluate...

greenmtnsun

02-03-2009 01:41 PM
greenmtnsun

Am I missing something about how data pump tasks work? I created a simple DTS package to split a table into two with one...

NH

02-03-2009 08:58 AM
NH

Hi, I have SSIS package wich executes a stored procedure using ExecuteSQL task to load data from staging to main tables and A SQL Agent job runs the...

xyz_jat

01-30-2009 12:38 PM
xyz_jat

I'm using SSIS 2005 for my package. When I launch it I have this error: Error: System.ServiceModel.CommunicationException: The maximum message...

Pasquale

01-30-2009 12:14 PM
xyz_jat

I have a single project with multiple packages that I recently moved to a new development server by copying the .dtsx files to the new server. Then...

Mike

01-28-2009 09:50 PM
Mike

I'm running a DTS through a stored procedure called from an ASP page on Server B. Server B is also the SQL Server. The DTS package is supposed to...

Tim

01-27-2009 12:36 PM
JM

I have a SQL 2000 server that is running the following DTS package and i just want to append a 7 to the EXT (extension) output. If I change the...

Brenda

01-23-2009 04:38 PM
tbradshaw via SQLMonster.com

I want to write a DTS Package that creates ones excel file for each record. I usually used the DTS to export to existing excel file, bot not to a...

yhareesh

01-23-2009 08:49 AM
Moby

Hi, Within SAP the table "TableName" resides which I query with select and update SQL statements using the .NET Provider\SAP Data Provider which is...

Johan Machielse

01-23-2009 03:41 AM
Johan Machielse

Hi, I have developed the ETL, which is getting the data from one source database. And it is working correctly. Now my problem is i have 15+ source...

Mallikarjun

01-22-2009 02:26 PM
Todd C

In a bank , there is nothing that gets deleted ,but gets marked for delete and the next time a select statement is issued ,those "rows marked...

MS Techie

01-20-2009 09:41 AM
jonock14@gmail.com

I'm trying to copy a database from one SQL 2005 server to another using the copy database task in SSIS. The basic copy of the database appears to...

Rob Nicholson

01-19-2009 10:02 AM
Rob Nicholson

Hi, I've been trying to use an SSIS project to acquire XML data and load it into a table within SQLServer 2008. The project is returning an error...

Jim Owen

01-17-2009 01:41 PM
Jim Owen

Is DTEXEC included in SQL Server 2005 Express Edition? If no, is it possible to put on a server only the dtexec.exe file in order to execute a...

Pasquale

01-16-2009 10:07 AM
Pasquale

Hello to everybody. I have a big problem. We have two server with SQL server 2k SP3 and w2k3 Server, when we try import one dts to another server...

Nelson de Freitas

01-16-2009 05:46 AM
Ireneusz Pisanko

We create DTS packages on development server and try to move the packages to test servers. We first extract the packages and save them as some kinds...

KrisC

01-15-2009 10:53 AM
KrisC

Hi there, Im fairly green at SQL so need a little help. I have a simple table with 2 columns. One is called userID and the second is called...

Gunna

01-15-2009 09:10 AM
Todd C

I'm using SQL 2005 and have three databases. Live Test (Restore of Live as of June 2008) CopyOfTest I created TEST then used MS KB 871973 (How to...

Titan

01-12-2009 02:52 PM
Todd C

Hi everyone, Predictive Analytics World's program for Feb 18-19 in San Francisco (www.predictiveanalyticsworld.com) has grown a bit since my...

EliseJ

01-11-2009 02:38 AM
EliseJ

Have SQL 2000 and wish to export only a row of data from a particular table but not the whole table itself. Once this is completed then we want...

Transam388

01-09-2009 09:00 PM
sql_noob

I am trying to deploy a SSIS package from my computer to a server that is being built to replace an existing server. When I run the .manifest...

Snowmizer

01-08-2009 04:49 PM
Snowmizer

When I execute the Transfer Logins Task I get the following error: " Error: Execution failed with the following error: "Windows NT user or group...

Kelly

01-08-2009 10:41 AM
Kelly

I need to pull a table from one server into another for testing purposes. I have a linked server setup from server A to server B and I run a query...

GPage

01-08-2009 10:19 AM
Russell Fields

Hello Everyone, I am trying to learn SSIS. I have Visual studio 2005 on my computer and Sql server 2005. when I go to programs->Microsoft SQL server...

Vinki

01-08-2009 10:13 AM
Paul Ibison

Hi All - new boy here and happy New Year to you... I have a problem I could do with some pointers on. I have an SSIS package to consume a Web...

Paddy

01-08-2009 06:49 AM
Paddy

Ydinalan disinformaatiosyydössä huomaa aiheen synnyttämän panikin. Totuus ei heitä miellytä. Mutta koska haluan varmistaa aina KAIKEN...

Niklas Räsänen

01-05-2009 11:47 PM
Niklas Räsänen

I am trying to run a SSIS package from Visual Studio on my machine. This package is to connect to a database but I am getting this error: The...

ronnie

01-02-2009 09:28 AM
Todd C

------------------------------------------------------------------- :::: Great Indian Developer Summit 2009 - GIDS .Net :::: :::: 24 April 2009...

Shaguf

12-26-2008 12:32 AM
Shaguf

Hi, Any idea on using schtasks.exe in BAT file to auto-executing the SSIS? I have issue in putting the value after /TR as below: "C:\Program...

Daniel

12-25-2008 09:48 PM
Daniel

Hi! I currently use conesans checksum component, but I need a md5-checksum pushed into a bigint (I believe conesans uses crc-32). Has anyone solved...

Gorm Braarvig

12-25-2008 05:15 PM
Gorm Braarvig

We are currently planing on migrating from SQL server 2000 to SQL Server 2008. I have read that DTS packages will work in SQL Server 2005 but I can...

Toni

12-24-2008 11:49 AM
Russell Fields

Hello, Iam syncing data from PROD to BETA using an SSIS package. After I load the data to stage table from PROD, I compare the dates between stage...

Abba

12-24-2008 07:30 AM
Tom Moreau