Dtsearch

dtsearch

Great Reads

The Pain and Anguish of DTS Script Debugging

by #realJSOP

When all else fails, fire off some events and bask in the glow of the IDE's Progress tab.

Latest Articles

The Pain and Anguish of DTS Script Debugging

by #realJSOP

When all else fails, fire off some events and bask in the glow of the IDE's Progress tab.

All Articles

top

Dtsearch

The Pain and Anguish of DTS Script Debugging

26 May 2011 by #realJSOP

When all else fails, fire off some events and bask in the glow of the IDE's Progress tab.

SQL-Server

dtsearch

debugging

How do i get only .zip files without specifying the file name

20 Feb 2013 by CHill60

Use something similar to the following to get the filename ...Dim d As DirectoryInfo = New DirectoryInfo("c:\\")Dim f As FileInfo() = d.GetFiles("*.zip")files(0) = f(0).Name 'actually you don't need the files array just keeping your variable name for illustration

dtsearch

I want to export more than one text file to a single Database table, using DTS. How can i do that,

21 Jun 2011 by Asif Iqbal A.Khan

After searching a lot, and by working 2 days on it, finally i got the solution.Visit the Link belowhttp://www.sqldts.com/246.aspx

dtsearch

DTS is not executing continuosly while exporting data in to excel file

27 Aug 2012 by kranthi1988

Hi all,Im working in SQL server 2000.Im trying to export the table data into excel file(file.xls defined destination data pump task).At the first time of execution file.xls creating successfully.And im trying to execute the package in next minit, it is showing error like 'file'...

Executing SSIS Package in TSQL

17 Sep 2012 by akosidandan

Hi experts,I have dts package that generate report to flat that accepts input parameter. The problem is although it execute and successfully create the report it does not generate my desired output. Wherein it supposed to extract 180 but just generate 87.Below is my TSQL queryuse...

T-SQL

dtsearch

SSIS

Executing SSIS Package in TSQL

17 Sep 2012 by Kuthuparakkal

I think the problem is Cusror does not wait for each package execution to completed. I would suggest a you do all this in a package using For Each container: For example:Using the Foreach ADO Enumerator in SSIS[^]

T-SQL

dtsearch

SSIS

SQL dataBase Script Using ASP.NET (SSIS, JOB)

29 Oct 2012 by ahp-1984

Hi, I have winform (Windows) application inside that i have to implement Work offline functionality.i.e.there is central database each user is connected to that db when he is online ,now suppose he wish to work offline then once he has clicked on the Work Offline then whatever data is...

How to pass a parameter to to stored procedure in DTS package?

21 Jan 2013 by Ravindranath.net

I have a store procedure that accepts one input paramter,,,i am trying to call the store procude from the DTS package but having hardtime to pass the parameter...i am trying to pass the table name as a value in the input parameter?Can someone tell me how to pass a value to the...

dtsearch

How to pass a parameter to to stored procedure in DTS package?

21 Jan 2013 by Zoltán Zörgő

Have you seen this one: http://www.aspfree.com/c/a/ms-sql-server/using-data-transformation-services-using-global-variables-with-the-dts-designer/[^]

dtsearch

How do i get only .zip files without specifying the file name

20 Feb 2013 by andilemtshali

Hi, the code below works BUT only when i write the entire filename and .zip extension in the path (Bold & underlined section) and the problem im facing is that filenames somtimes change. so how do i get only .zip files without specifying the file name in a folder? Please helpImports...

dtsearch

Get Data of an Oracle Table from Sql Server Stored Procedure

17 Jan 2014 by leocode7

Dear Friends,I will develop a Store Precedure in SQL Server, but I need to process datafrom a table but this table is in an another Database in Oracle.How a cand access the data??? please share me any code or link or example where I can do this.Thanks in advance.Leonardo Ayala R.

Get Data of an Oracle Table from Sql Server Stored Procedure

17 Jan 2014 by Krunal Rohit

http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html[^]

Get Data of an Oracle Table from Sql Server Stored Procedure

17 Jan 2014 by Christian Graus

I would write a local or web service that talks to both machines and passes data between them.

Get Data of an Oracle Table from Sql Server Stored Procedure

17 Jan 2014 by Jörgen Andersson

You set up a database link[^] to the oracle server.

File spliting based on parameter in ActiveX script

1 Oct 2014 by Member 11122317

I want to load a txt file into sql table through DTS.How to split the tilde separated file into rows based on parameter using Active X script.

ActiveX

dtsearch

Communication with the underlying transaction manager has failed when all settings Ok

19 Feb 2015 by chathuranga abeyrathne

I have implement a application in VPN using C# i used the TransactionScope to manage the database Tranasactionsand i setting up the MSDTC Security setting as normal in both server and client pc and my setting Image Sampleit works fine in the same ip range as eg client 192.168.10.20...

dtsearch

I want to export more than one text file to a single Database table, using DTS. How can i do that,

20 Jun 2011 by Asif Iqbal A.Khan

I am able to export one file successfully, but not multiple file....

dtsearch