ASP.NET, SQL Server, WPF, C#, VB.NET

Hello, 
 
When I designed and deployed DTS packages, I often stored them in SQL Server 
 
or in the file system and ran them from batch scripts (using DTSRun.exe) or 
 
from ASP.NET applications (either case, most of them weren't run at the SQL 
 
Server itself). 
 
I was hoping I could do the same with SSIS, but it seems you can't run SSIS 
 
packages from servers without SSIS installed, and SSIS requires a SQL Server 
 
license... Since I'm stuck with a single SQL Server, the implications of 
 ...

I have a single SSIS package that executes 10 different SSIS packages.  All 
 
are stored in the sql server package store. 
 
When I execute the outer package manually, it completes successfully.  If I 
 
execute it from a sql agent job, it fails.  Also, if i change the job to 
 
point to each individual ssis package, each run successfully, i just cannot 
 
point the sql job to a package containing child packages.  The error returned 
 
in the logs is: 
 
-1073602332,0x,Error 0xC0012050 while pr ...

I have an execute SQL TASK going and after it completes I want to go to a 
 
Microsoft OLE DBServer. It wont let me use the regular after completion bar, 
 
any ideas?

So, I used the SQL Server (2005) Import and Export Wizard to create an Import 
 
operation. I saved it to SQL Server instead of the file system. Now I can't 
 
find it!! 
 
The help files states: 
 
"If the wizard is started from SQL Server Management Studio or the command 
 
prompt, the package can run immediately. You can save the package to the SQL 
 
Server msdb database or to the file system." 
 
I've looked in the msdb database and have no clue how to find this SSIS 
 
package. 
 
-- 
 
Michael Hockstein

I have the following command that imports my package into SSIS but i 
 
can't seem to set ProtectionLevel 5 (ServerStorage). I can do this 
 
manually if I select import package but not from the command line. 
 
DTUtil  /DestS SERVER\INSTANCE /FILE "D:\MyPackage.dtsx" /COPY 
 
SQL;"\Packages\MyPackage" 
 
Does anyone have any suggestion please. 
 
Regards 
 
Toby.

Hi everyone, 
 
Short introduction; I work for Biretco BV in the netherlands; we are a 
 
retail organisation for bicycle stores! 
 
Now the case is : 
 
Everyday we sell products in each store. (approx 500 shops) 
 
At night the shops upload their file on our FTP.. 
 
I collect the files (there are 500shops x 1 file) about 500 files 
 
everyday 
 
All the files have the same format: 
 
HEADERRULE: 
 
00093;Profile Rudie Assink;Raalte;20.07.06;2.0 
 
DATARULE: 
 
20.07.06;08:55;29;0200006543;;2; ...

Lady only 24-Hrs +91 9810577227

Hi, 
 
Do you know how to run a lookup query with multiple parameters? I am 
 
passing them, using a comma: 
 
DTSLookups("AddPart").Execute(Value1, Value2) 
 
But every time get an error "cannot use parentheses when calling a sub" 
 
As suggested in some groups, i tried 
 
Call DTSLookups("Addpart").Execute(Value1, Value2) and 
 
DTSLookups("Addpart").Execute Value1, Value2 
 
But they do not work either, probably, because it's not really a 
 
function 
 
Thanks 
 
Irene

I would like to execute a ssrs report from within a ssis foreach loop but 
 
there is no task especially for this so I tried to use the web service task 
 
and connect to the ssrs web service but ssis complained about the ssrs wsdl, 
 
does anyone know why and what I can do to fix? Thanks. 
 
-- 
 
John Pryor

Our product uses a DTS job to copy between two databases. Whenever we modify 
 
this DTS package, we notice that the Owner and Machine fields are 
 
automatically filled in (when you view the Package->Properties values). The 
 
problem here is that usually one of our devs modifies the job on his box and 
 
submits it. This results in our machine names and domain username leaking 
 
out as part of the package. We could use one of our build machines with a 
 
builder account, but this still mentio ...

Is there a way for DTS to use a directory server as a data source?  The 
 
only use i've seen for the directory services OLEDB provider, 
 
ADsDSOObject, is in the typical workaround suggestion using a 
 
query/view thusly: 
 
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 
 
'ADsDSOObject', 'adsdatasource' 
 
EXEC sp_addlinkedsrvlogin 'ADSI', 'false', NULL, NULL, NULL 
 
CREATE VIEW OpenldapOrgView AS SELECT displayName as [Name] 
 
FROM openquery(ADSI, 
 
'<LDAP://ld ...

I'm looking for a way to have a DTS job to shut down windows once it is 
 
complete. Is it possible, perhaps through an ActiveX script? 
 
Thanks!

I'm building the dts from scratch... The goal is to build a dts to 
 
export some data (sql statement is a must) from one table to a text 
 
file. I've built a package, connections (two of them, one for the sql 
 
server, and one for the text file), steps (only one), one task with one 
 
custom task, and one transformation object (there is only one column in 
 
the select clause in sql statement). However, when I execute the 
 
package, I get the following error: 
 
"Incomplete file format infor ...

Are there some errors which are not trapped by the Failure workflow on DTS ? 
 
I set up a package to load data from one system to another.  It failed 
 
because the file was in use.  The following step of the package was set to 
 
execute on the Failure of that step but it did not run.  I tried changing the 
 
workflow to Completion and it still did not run.

Hi, 
 
I'm hoping someone can help me with an error message i get in a bit of 
 
VBScript within a DTS Package. 
 
The error message says: 
 
"ActiveX component can't create object : 'Dir2.Dir' 
 
I'm using SQL Server 2000 and this bit of code has been taken from a 
 
colleague (who is now on holiday).  I am not terribly familiar to 
 
VBScript, but nevertheless the "Dir2.Dir" does look very odd to me - 
 
i'm not sure what type of object is trying to be created.  Does anyone 
 
know what this m ...

Hello, 
 
I am trying to generate a DTSX via C# Source that just copies one table 
 
column into another table. Starting with a already existing package that 
 
does that my analysis failed finding all information within the package like 
 
sourcetable or destination table. Where I can retrieve all necessary 
 
information out of the Microsoft.SqlServer.Dts.Runtime.Package object? 
 
regards 
 
Mark

Hello, 
 
In my SSIS package, I generelly load a lot of data for all customers from 
 
database A to database B. However, sometimes, I only want to load data for 
 
specific customers. I've added a string variable used as a parameter called 
 
CustomerFilter, and a SplitByComma SP which, given a comma-separated input 
 
string, returns one row for each element in the CSV-list (although this is 
 
somwhat of a hack, I didn't find a better way to pass arrays as "parameters" 
 
into the SSIS packag ...

Hello All, 
 
Wondering if anyone ahs thoughts on what the best practice for ownership of 
 
a DTS package is? 
 
We have several biz-critical packages that are owned by individual 
 
developers. 
 
One of the owner/developers has recently terminated employment and we wish 
 
to remove the associated login. 
 
Obviously this will create problems. 
 
Moving forward I wondered what any of the gurus present here would recommend 
 
as a bets practice for this type of thing as well as pros/cons? 
 
Thanks in advance. 
 
Tam.

can anybody tell me the best way to load data fast using SSIS?  I'm trying to 
 
just disable the indexes on the destination table before i truncate and then 
 
load, but using the fast load option gives me an error saying that it was 
 
unable to produce a plan because the clustered index is disabled. 
 
does anybody know what's the best way to do this, because i kinda thought 
 
disabling indexes was the best way for this kind of bulk load operation in 
 
SSIS.  I can make it work using the non last load option, but it's magnitudes 
 
slower.

I need to create a DTS package that checks for files on a server and if they 
 
exist I need to import them into a SQL 2000 table. 
 
I created an ActiveX script to check for the files, on success of the 
 
scripts I run a data transformation from the DBF into SQL.  The issue is if 
 
the first file doesn't exist I dont want to fail the job I want it to go 
 
check for the next file name.  In an activeX script is there a way to stop 
 
the failure and move to another step in the package?  Can I  ...

Hi 
 
I can't believe I've never come across this before, I've deployed 100+ 
 
DTS packages into the kind of environment where I wouldn't be in work 
 
right now if I'd got it wrong ;) 
 
The problem is with deploying a DTS package onto another server.  So I 
 
change the database and server properties of the Connections.  The DTS 
 
Designer (which I think is the villain in the piece - DTS itself runs 
 
powerfully and well, the designer is unbelievably stupid about implied 
 
changes) chucks  ...

Hi Everybody, 
 
1) How Do I execute a DTS package from ASP? 
 
2) How Do I execute a DTS package from a Stored procedure? 
 
Any help is appreciated. 
 
Thanks, 
 
Sunny.

Hi, 
 
I used to use DTS for transferring data between Informix and SQL Server 
 
and it worked very nicely. I now need to replicate data between Oracle 
 
and MySQL and need a similar tool. I can't use DTS because I no longer 
 
have SQL Server, and I can't use Oracle or MySQL's replication service, 
 
because they only work between 2 Oracle or 2 MySQL databases. 
 
I don't need anything particularly sophisticated, just something which 
 
can copy data between an Oracle and MySQL database, and  ...

Hi, I'm trying to create a custom task in C#. 
 
I'm starting from the MSDN example in the Task Class page 
 
My question is: 
 
Where can I find the type DtsTransaction? (wich assembly and 
 
namespace?) 
 
Thanks, 
 
Renzo.

Hi, 
 
I'd like to import rows from an Excel File to an SQL Server 2005 table. 
 
One column of my table is 500 varchar big and my Excel column contains 
 
259 letters. The import task aborts because he has to truncate this 
 
particular column. When loading all failed rows in another excel the 
 
specific column is only 255 letters long. 
 
How can I solve this problem? 
 
Tanks Florian!