Viewing 15 posts - 10,066 through 10,080 (of 11,678 total)
chris.stuart (2/24/2011)
February 24, 2011 at 12:38 am
chris.stuart (2/23/2011)
February 23, 2011 at 11:53 pm
Chrissy321 (2/23/2011)
How do you tell your packages where the configuration database is? Environment variables?
Jup. That is an indirect configuration.
I have a WMI script that can automatically generate that environment variable...
February 23, 2011 at 2:40 pm
Chrissy321 (2/23/2011)
You don't have to create an XML config file for each package, just for those who have special configuration needs.
All my packages have special needs. They point to a...
February 23, 2011 at 1:51 pm
Log shipping (it has nothing to do with SSIS):
http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx
http://msdn.microsoft.com/en-us/library/ms190640.aspx
http://msdn.microsoft.com/en-us/library/ms187103.aspx
This is more work for a DBA then for a developer (as are the other solutions I mentioned).
February 23, 2011 at 12:11 pm
Chrissy321 (2/23/2011)
1) a single xml file
2) a file for each configuration
3) a file for each package
3 seems to defeat the purpose a bit....
February 23, 2011 at 12:09 pm
pwalter83 (2/23/2011)
Thanks for your reply.
The equivalent tables are on a different server. So basically, the scenario is that when the records are added to the tables in the...
February 23, 2011 at 7:50 am
michael.kaufmann (2/23/2011)
SUPER SQL STAR (2/22/2011)
The directories for the default data files, log files and backups are stored in the system registry....
February 23, 2011 at 6:40 am
First of all, is the XML file an indirect configuration or a direct configuration?
Meaning, is the location of the XML hard coded into the packages? If it is, you have...
February 23, 2011 at 5:56 am
pwalter83 (2/23/2011)
I have a business requirement to create an SSIS package that is triggered whenever a new record is added to the table in the database.
What the SSIS package...
February 23, 2011 at 5:47 am
darth_vodka (2/23/2011)
yepProvider=OraOLEDB.Oracle.1
how do i know if that's Oracle 10,11 - 32 or 64 bit?
how do i go from the provider name to the DLL path?
Doesn't the provider work on all...
February 23, 2011 at 5:22 am
The idea of importing an Excel file is to look at it as it is a database.
The sheets are the tables of that database. And of course, the tables contain...
February 23, 2011 at 12:58 am
ns.sharath (2/22/2011)
February 23, 2011 at 12:06 am
GilaMonster (2/22/2011)
Koen Verbeeck (2/22/2011)
I'd argue to give the ETL team read rights in production.
Disagree. But then my main experience is in a financial environment. The data in those tables is...
February 22, 2011 at 11:55 pm
Viewing 15 posts - 10,066 through 10,080 (of 11,678 total)