PREEMPTIVE_SHAREDMEM_GETDATA error during SSIS
Jan 13, 2015 · I have an SSIS package that is dynamically generated and executed that basically does a pull from a source database and use SQL Server Destination to inject into the …
SSIS do not load data from view when run using SQL job
Jul 10, 2012 · Since no transformation is required so I try to use a SQL command (insert into table A, select column1, column2 from view), again it works absolutely fine to load data into table …
SSIS xml configuration file not working - social.msdn.microsoft.com
Feb 9, 2015 · I have created the xml config file and also created sqlserver configuration table to store the data connection info.
Unable to deploy SSIS package due to A required Prvilage not …
May 24, 2019 · I also tried to follow the first step by adding permissions in the DCOM menu however this has not resolved the issue, even after restarting the SSIS service. Following up …
Importing CSV Files using Microsoft SQL Management Studio into …
Dec 16, 2013 · Have you tried doing the import using a SQL Server Integration Services (SSIS) package? SSIS is built and optimised for this kind of work but also it may give you better …
How to execute SSIS package that pulls data from a server on a …
Aug 12, 2008 · When i execute the package that pulls data from the public domain, the package has a configuration file that has a username/password in the config file which is a named sql …
Running SSIS package with SQL Agent Job - protection level settings
Since the package has worked up until now, I have not changed any of the components. Just playing with protection level and the like to get it to work since the sql agent job is now using a …
Separation of development and production environment
Feb 14, 2012 · I am in the middle of setting up a current Data Warehouse to a development, test and production environment. I have used the Configuration Manager for both Reporting …
SQL Server Package Configuration for Multiple Packages
Jul 9, 2015 · I have a number of SSIS packages all of which use the same SQL Server package configuration.
Alerts in ssis package - social.msdn.microsoft.com
Jul 7, 2012 · Inside the ole db source i wrote the join queries as for two alerts. Is it correct way to create a package? Please give me solution any other way.