i need to create a simple package that will: 1. insert a data to table A2. get the identity_scope3. insert multiple rows to table B with the id from table Ai created one, but it only does bulk insert, so i want to redo it again.
Ive created an SSIS package (vs2005, so vb.net only) One of the tasks has to unzip a zip file. To do this ive used java.util.zip library and written some code to unzip the file. Ive just been asked if its possible to use something other than a java library as our network engineers dont want to put the this on our server. Is there anything similar to java.util.zip that I can use in a vs2005 package ?
I want to replicate data from branch server to main server using SSIS with scheduling .. Every daily at 12 AM. I can have more than 5 branch servers, I need to transfer datas from these server to my main server. how can i do with SSIS and Error handler in SSIS , While replicating if some error happens , it need to save log file or send mail to me Like this i need to do.. and also i need to scedule the created SSIS pac
Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
I am migrating a project from C#.Net (Console Application that acts as a server) to SSIS 2005 based one as the task involves around Database. I can able to use only VB.Net in SSIS 2005 version. The problem is, the C# code has XSD, XSL operations over XML along with XML processing such as XML creation/generation, compressing the file, and saving the file into DB. As it looks like the above operations are not achieved without using VB.Net in SSIS, I am blindly converting into VB.Net inside SSIS.
Also, I would like to know how to import/create XSD files in VB.Net in SSIS. It is not like Visual Studio to add a new XSD file and design the same that allows generating the appropriate code.
For your information, I am using Typed DataSet.XSD file in C# which needs to be converted into VB.Net in SSIS. There is no provision to add Typed DataSet XSD files into VB.Net in SSIS 2005.
i am trying to create a import package to import data from a CSV file. When I create a flat file source and take a look at the preview I see that the fields are mixed up. Some fields are ok, but quet a few arent. When I open the CSV in excel or a other program it looks good, all rows are ok. When i import the CSV in access it is also ok. So I'm a bit confused where the problem lies. all the settings are standard. The strangest thing is that when i replace al the semicolons to for instance tab's the problem keeps.
I have created an SSIS package to fetch the details from an Oracle database and import the details in to SQL servers table. In development region the client provided the connection description for oracle server as shown below: Using the above string I have selected Microsoft OLE DB provider for Oracle and gave xxxxx:1543/AU1D as server name and provided the username and password. It got connected successfully. (DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx.abc.XYZ.com)(PORT = 1543)) )(CONNECT_DATA = (SERVER=dedicated) (SID=AU1D) )) For Prod environment the Oracle servers connection description is: C10P =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyyyy.abc.XYZ.com)(PORT = 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = zzzzz.abc.XYZ.com)(PORT = 1524)) (ADDRESS = (PROTOCOL = TCP)(HOST = vvvvv.abc.XYZ.com)(PORT = 1524)) (LOAD_BALANCE = yes)(CONNECT_DATA =(SERVICE_NAME = C10P. abc. XYZ.com)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)))) Now I don't have the SID to use in the connection.
I have around 10 "Excute SQL Task" events in sequence. Each Task uses the same two date parameters, which are declared at the top of each script. Is there a way to set these two at the start of the process instead of within each sql script?
i'm trying to retrieve the data from database using ssis package.. database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production database..
now what i want is to retrieve the data for each four hours.. i.e i want to execute the package for every 4 hrs..
now what i did is i have taken a database transfer task and from the source i.e production database i want to transfer to my database which works fine..
but what is the problem here is for every 4 hrs whole DB is replaced in my system
i've given overwrite TRUE..
Here user enter the data into database for every 4 hour is minimum 10 MB of data.. instead for replacing the whole database for every 4 hrs is there any solution that what user enter data into database only that much amount of data should be append into my system..
I'm trying to run my SSIS packages as a step inside a sql agent job.This runs normally when the package uses the SAME database as used to create my job.The problem occurs if I create a job to run the package and this package must execute queries in another database. Probably authentication problem. So how to authenticate my package and the job runs normally ?