In SQL2000 DTS you could execute a package from the DTS designer and see how long each step took. Is there any way to do this in SQL2005 SSIS? -- Jeff Lynch "Ramblings From A [Microsoft] Connected Universe" http://codebetter.com/blogs/jeff.lynch ...more >>

Hello: I have a web application from where I need to execute a DTS, my platform is SQL 2000 and .net 2003. From a Vb.net module I want to execute the package, my question is: does the package need to be STRUCTURED STORAGE FILE or could it be SQL SERVER package (local to the server)...more >>

I have a flat file with 3 million records.One of the field is numeric. What I am trying to do is transform the flat file data into sql table.The DTS Package fails. The Reason it fails is that one of the Numeric Field has Blank value in it.what do I need to do within a DTS Package so it convert...more >>

Hi, We have a large development team and they create DTS to load some data into DEV environment and often need to change the connection properties. Since only members of sysadmin role has access to change the settings if there a way to give access to the developers so that they can modify the...more >>

We have a number of DTS packages running on a SQL 2000 server, pulling data from a non-relational accounting database. The package is set up using an ODBC connection to this database, which uses a system dsn on the machine. I want to re-create all this over on a SQL 2005 system. I have ins...more >>

I need to move some data generated from a SQL Server 2000 scheduled job over to Exchange 2003 calendar. After some research, it appears that a DTS package could do the trick for me. My questions is, does anyone know how to connect to Exchange from SQL DTS? I know there should be some suppor...more >>

I am trying to copy a "snapshot" of a remote sql server 2000 database to a local sql server 2000 database. I just want to run a simple Copy Objects dts, but it is choking on a user defined function. Another object needs the udf but the udf hasn't been created. Is there any straightforward...more >>

Environment: SQL 2005 EE RTM I am trying to provide a dynamic XMLA string to an Analysis Services processing task using a package-level variable. My XMLA string is about 5400 characters long. I am able to put the value into the variable in a Script task, but it goes down in the AS processing...more >>

Hi, Environment : SQL Server Intergration Services Beta 2. Requirement is that moving the contents of all CSV files in a particular folder to multiple tables in database. What we have done so far. In the Control Flow task we have used the Data Flow Task in Foreach Loop Container in order...more >>

Hi there, In my DTS package, I want to define my connection DataSource using dynamic properties. I'm using a query to initialize the source. Can I use a global variable in this query and how to use it ? Thanks for all VinCe...more >>

I'm sure there is a simple answer to this but it eludes me at the moment. I’m using the Developer Edition of SQL Server 2005. The MSDB node under Integration Services->Stored Packages refuses to open. It always fails with a login timeout message and that the connection was actively refu...more >>

How can I insert the results of a query into another table? TIA RC- ...more >>

Facts: I have a Windows 2003 Standard server that has SQL 2000 Standard installed. Both MSSQL and ServerAgent services are running under a windows user. Issue: I created a simple DTS package, and I want to be able to run it in a scheduled job. I have created the scheduled job for the package...more >>

I am trying to import data into SQL 2000 through an ODBC and keep getting an error, I tracked down the error and it is because the program that I am trying to pull data from has invalid dates (by design, not mine). It uses the 31st day in all months. I am trying to get figure out how to correc...more >>

I have a classic one. Never the less I cannot get around. When I run package, it executes fine loading file from specified location. Schedule job fails when tries to run that package reporting ‘Error string: Error opening datafile: Access is denied’ Facts: Path indicating file does ...more >>

In my ADP I start a DTS pakcage from my vba module (use the object dts.package2), I display the status of the progress in a pop up form. My issue is the DTS package takes ages to complete and if a user use another application and come back to the Access application the got a pitch white screen l...more >>

Hi, i have created a stored procedure and its running fine. i am sure that sproc doesn't have any problem. after that i integrate this sproc to an application. whenever i execute sproc from query analyzer. its running fine and doing expected job. but whenever i am calling it through applicat...more >>

Hi All, I am trying to import all tables from an Access 2000 database into a SQL Server 7.0 database. The import seems to work fine and says it was successfull, but the tables are not listed under the Tables node. If you look at the permissions for the Public database role, the tables are lis...more >>

Hello, I have a text file that is 27 megs. I import it into a single SQL server varchar field and delete some rows that aren't properly delimited. I then output the file to a new text file. The text file comes out 405 megs! I have tried shrinking the size of the varchar field and change nvar...more >>

I have the developer edition of SQL Server 2000. I also have a DTS package that imports from a text file into a SQL Server 2000 database table using the standard ODBC driver for SQL Server supplied with DTS. It worked fine UNTIL I added ONE column to my destination list in order to import furt...more >>

I have two tables that I need to compare. The purpose of the comparison is to check for duplicate records, or better said, check for new records in the newer table. I then want to add the new records to the old table. The newer table is expendable but the older table is the actual productio...more >>

Hi, Im having trouble de-activating a task (DTSStep_DTSDataPumpTask_1) if a certain datasource has no data in it. The error which i am getting is: Invalid Step Result Value. Could anyway help? Raj This is the script i am executing: Function Main() Dim oFSO, File, oStep, oPkg,...more >>

Dear All I have arround 100 packages in all packages I have put IP of the server in the connection. Now I want to use all this package on other 2 servers. So I need to change the IP in the connection for all this 100 packages. Is there any easy way to do this? I dont want to open each ...more >>

I have a report output generated for each vendor and I want to email this attachment to the appropriate vendor. The problem is how can I send a email to each vendor with a attachment for the DTS email task or the XP_SMTP procedure. Thanks Karen ...more >>

I'm trying to work out what permissions I need to give a user in order to create, deploy and execute a 2005 package from a job. I have a local account machine\TestDev that has a login to the server (TestDev) with db_dtsltduser, db_dtsoperator and SQLServerAgent User roles in msdb. I have a sec...more >>

I need to update data from SQL server(our database) to Oracle database(Target system's Database). I am using Data Driven Query Task and parameterized Update Query in SQL Server DTS. Case1: when I am using "Oracle provider for OLEDB" as connection object to Oracle database In DTS package o...more >>

I can't start the SQL Agent in an MSDE installation. It stops right away. The Error log says : <<SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).>> Both the Agent and the SQL ...more >>

Hi I would like to export sql server tables in text files. I have a metadata table "tables" with the tables name that I want to export. i would appreciate some idea how can i do that. The main porpouse .. when I have more tables I just want to enhance the "tables" table indormation... I am goi...more >>

My scenario is like this: We have 9 equal databases located on 9 different physical locations in the country. I am going to import data from these databases into a dataware house using the same sql statements. In our current solution there are 9 equal DTS-packages that each connect to a ...more >>