Hello, I have an SSIS package that loops through files in a folder using a for each file loop control object. It then runs a data flow task for each...

GPage

10-07-2008 04:20 PM
GPage

I am having trouble in working with ForEach Loop in SSIS. If anybody can give me some tips, it will be very appreciated. What I am trying to do is...

CJ

10-07-2008 10:51 AM
CJ

Im using Visual Studio 2008 for developing Web, Windows applications, Services etc. I have installed SQL Server 2005 Developer Edition too...

Mirek Endys

10-06-2008 01:13 PM
Brad

Hi all, I have a script task in my SSIS package where i use a user variable that is read from the configuration file. It works fine. But if i had a...

parez

10-03-2008 08:37 AM
Todd C

New to SSIS so bear with me.... I have migrated a 2000 DTS package to a 2005 SSIS package. The migration wizard converted all DTS tasks(20 tasks)...

Swit

10-02-2008 06:39 PM
parez

hello, does anybody know of an effective training place for ssis in the usa? thanks

lark

10-02-2008 06:14 PM
lark

I'm looking for suggestions on how to handle a situation that occurs randomly. I have a Job that runs a dts package every 2 hours that takes 3...

Jim Abel

10-01-2008 07:35 PM
GPage

Did you resolve this? I have the same problem. The change in connection works fine for some data flows but for others I have this...

Eric

09-30-2008 07:01 PM
bobthecoder

I have two SQL 2005 Servers which are located on separate computers with MS Windows Server 2003. Those computers have connection through VPN....

dvrus

09-30-2008 02:23 PM
dvrus

I think, that I have to do something wrong. In periodicaly running updates, at the end of the transformation, I usually use OLE DB Destination and if...

Mirek Endys

09-25-2008 11:00 AM
Charles Wang [MSFT]

I made SQLCLR function that returns SqlDateTime form integer value. I deployed it succesfully on the server but I dont know, how to use it in...

Mirek Endys

09-25-2008 10:58 AM
Charles Wang [MSFT]

can any body tells what is look up transformation and how to configure this? *** Sent via Developersdex http://www.developersdex.com ***

ankit kar

09-25-2008 08:38 AM
Todd C

Hi, I made a dtsx file with dtswizard. If I run it with 'dtexec /f file.dtsx /va thank you chris -- Message posted via SQLMonster.com

elektrongyorsito via SQLMonster.com

09-25-2008 06:19 AM
elektrongyorsito via SQLMonster.com

Hi, I would like to ask if it is possible to change the default options of dtswizard (sql server 2005)? I have more than 300 tables, and I would...

elektrongyorsito via SQLMonster.com

09-25-2008 06:02 AM
elektrongyorsito via SQLMonster.com

hi I have a database server with MSSQL 2005 installed and two webserver work on VS.NET 2.0 It works fine before.But when connecting the dbserver...

Jim.Huang

09-25-2008 02:20 AM
Jim.Huang

I am having 80 millions record in a table. I want to move all the records to a destination table using SSIS. I am using OLEDB Source and OLEDB...

Ahamed Faridh

09-24-2008 01:28 PM
Todd C

I am having 34 columns in the source and destination table, i want to move all the data to the destination table in single transformation by SSIS. I...

Ahamed Faridh

09-24-2008 01:13 PM
Todd C

I am having 34 columns in the source and destination table, i want to move all the data to the destination table in single transformation by SSIS. I...

Ahamed Faridh

09-24-2008 12:39 PM
Ahamed Faridh

I am executing a SSIS package from Management Studio using the DTEXEC command in SQLSERVER 2005. The package is executed successfully. But i am not...

Ahamed Faridh

09-24-2008 12:39 PM
Ahamed Faridh

Im trying to rename output columns in DataReader Source to be more readable. For example: in the source table is column named GLMPUJ. After...

Mirek Endys

09-24-2008 07:41 AM
Roy Harvey (SQL Server MVP)

I'm sure the answer is no because you can't look up, only down, but I want to make sure :) I have a SQL 2000 server and a SQL 2005 server. I need...

ngan

09-23-2008 04:17 PM
Russell Fields

Hi, I wanted to make sure you were all aware of these upcoming events. There is a seminar in Predictive Analytics on Oct. 24-25 in DC, and in San...

Elise Johnson

09-23-2008 03:28 AM
Elise Johnson

What specific things have to do, that I will be able referencing my own assembly in the script editor in DataFlow ScriptComponent. I Strongly signed...

Mirek Endys

09-22-2008 11:38 PM
Charles Wang [MSFT]

I'm running a dts (pre ssis) pkg under mgt studio/dts 2000 pkg designer and am finding that unless I open each transform individually (after opening...

steitelbaum@mhrx.com

09-22-2008 02:43 PM
steitelbaum@mhrx.com

I am tasked with downloading from an FTP site, a flat file (an inventory of loan files) that's about 220mb large. I then rename it to a text file...

Rockitman

09-22-2008 10:49 AM
Rockitman

HI I want to change the source table using the DSO scripting . For example the particular dimension has the source table as TABLE1 using the DSO...

santosh

09-22-2008 04:39 AM
santosh

HI I want to change the source table using the DSO scripting . For example the particular dimension has the source table as TABLE1 using the DSO...

santosh

09-22-2008 04:39 AM
santosh

Hi I am in Microsoft Visual Studio 2005 - Business Intelligence Project - SSIS package. I have my Excel data sitting in a global variable as an...

Marc in Oz

09-21-2008 07:30 PM
mpaisley@optusnet.com.au

Hi experts: What are some good approaches on developing a syncing process of over 400 tables from one Access database to a SQL Server database that...

AL

09-20-2008 09:48 AM
AL

hi sir i m getting run time error 214721900(80040e14) while inserting some value in the database althoug i dont find anything wrong with the syntax...

vinay

09-20-2008 08:09 AM
vinay

Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from...

Sudhakara.T.P.

09-19-2008 10:19 AM
Daniela

Hi, I am new to SSIS. I created a pockage that extracts data from SQL and export to an Excel spreadsheet. This package will run every day. The...

Daniela

09-19-2008 09:06 AM
Daniela

Im developing custom DataFlow Component with my own UI Editor. When I want to debug this component, I have to: 1. Uninstall old assembly from GAC 2....

Mirek Endys

09-18-2008 10:36 PM
Charles Wang [MSFT]

Hi I am trying to learn SSIS by trail and error and I just need a little push here or pointed in the right direction :-) I have a file dump from a...

sippyuconn

09-18-2008 04:27 AM
Mark Han[MSFT]

I have an SSIS job, SQL 2005 SP2, Windows Server 2003, that imports data from multiple databases into local SQL tables. The job imports data from...

DB

09-17-2008 01:18 PM
DB

Hi All, I have an an ssis package with a lot of sql tasks. After finishing the first task it goes to the next and so on. All tasks on error (the red...

parez

09-16-2008 11:17 AM
parez

Hi, I have a DTS package pointing to a database using an ODBC for Oracle. The server field is actually the database name and there is no reference...

NathanG

09-16-2008 10:55 AM
matteus

Hi Using dts.dll and C# code we were importing data from text file to data base. Every thing was working fine till we run the patch for SQL Server...

Rajashekar

09-16-2008 09:20 AM
Rajashekar

I can not get my global variables to update. For a simple Execute SQL Task, I mapped the variable to the global variable in the Result Set page....

Marty

09-16-2008 09:05 AM
Todd C

I want to update my Variable in the DataFlow. Im using Script Task. Is there a simplier way to do it? Something like DataFlow Transformation...

Mirek Endys

09-16-2008 04:58 AM
Mirek Endys

Im developing custom DataFlow Component with my own UI Editor. When I want to debug this component, I have to: 1. Uninstall old assembly from GAC 2....

Mirek Endys

09-16-2008 04:48 AM
Mirek Endys

I am a SQL Server 2000 developer and recently moved to SQL Server 2005 environment. I need to know what is the equivalent of "dynamic properties...

Test Test

09-16-2008 03:10 AM
Gerald Aichholzer

I had some DTS's from SQL 2000 that I brought over to SQL 2005. It was doing a lot of date code manipulation, etc, and have gotten it to work in the...

Blasting Cap

09-15-2008 04:12 PM
Blasting Cap

I am trying to export the results of a query to a flat file. When I run the package I get all the rows in a single record - there are no CRLFs. On...

cs_hart@yahoo.com

09-15-2008 02:09 PM
cs_hart@yahoo.com

Is there a way to align the dts package 'name' property with the value in the 'name' column of sysdtspackages? I know if you resave it, then this...

mr_acann@hotmail.com

09-11-2008 07:00 AM
mr_acann@hotmail.com

Is there a way to align the dts package 'name' property with the value in the 'name' column of sysdtspackages? I know if you resave it, then this...

mr_acann@hotmail.com

09-11-2008 06:57 AM
mr_acann@hotmail.com

Is there a way to align the dts package 'name' property with the value in the 'name' column of sysdtspackages? I know if you resave it, then this...

mr_acann@hotmail.com

09-11-2008 06:53 AM
mr_acann@hotmail.com

Hi, Can anyone tell me if its possible to check the file size of a resulting text destination file in DTS when it has finished exporting and if it...

Phil

09-10-2008 01:28 AM
Phil

Hi, My main objective of this DTS is to create an Access Database with datestamp on the back of the filename. It will export data from SQL query in...

cyclone9

09-09-2008 10:23 AM
cyclone9

Hello there My local computer has upgrated to 2008 and far server is still 2005. I took package i've made on 2008 and save changes on my visual...

Roy Goldhammer

09-09-2008 04:24 AM
Roy Goldhammer