Viewing 15 posts - 8,806 through 8,820 (of 11,678 total)
By default, when you create a package in BIDS (and thus also an SSIS project), Visual Studio saves the files in the My Documents folder. Somewhere in ..\My Documents\Visual Studio...
November 14, 2011 at 12:49 am
There are a few options:
* you can first check if the primary key exists or not. You can do this with TSQL, using a self-join or by using EXISTS, or...
November 14, 2011 at 12:46 am
What datatype has the numeric column in the SSIS dataflow?
November 14, 2011 at 12:43 am
Does the config file contain sensitive information, such as passwords?
November 14, 2011 at 12:42 am
I haven't seen this behaviour before, but the only thing I can think of right now is the following:
AD uses some sort of synchronization between the servers (I'm not really...
November 14, 2011 at 12:40 am
The initial load you can probably do with the Import/Export wizard in SSMS.
It gives you the ability to quickly generate an SSIS package that will load the 51 tables as-is.
Regarding...
November 14, 2011 at 12:37 am
Jeff Moden (11/11/2011)
November 14, 2011 at 12:32 am
Regarding the sequence number:
you'll need to store this somewhere outside the package, probably some sort of configuration file or inside the SQL Server database. You cannot store this inside the...
November 14, 2011 at 12:17 am
It depends 🙂
Daily partitions will allow you with faster processing speed, as you can only process the current (or past) day.
But as you said, if most of the queries are...
November 14, 2011 at 12:13 am
There are several options.
This article series at here at SQLServerCentral covers them all:
http://www.sqlservercentral.com/articles/Analysis+Services+(SSAS)/69467/
November 14, 2011 at 12:10 am
First of all, read the Data Warehouse Toolkit by Ralph Kimball.
Practically an industry-standard, and a must read for everyone who starts in data warehousing.
The book suggested by JonFox is an...
November 13, 2011 at 11:54 pm
maheshkrishnas (11/13/2011)
Actually in derived column i used the substring and Instring ,and i got the solution but the problem is in...
November 13, 2011 at 11:31 pm
Trey Staker (11/11/2011)
SQLRNNR (11/11/2011)
Trey Staker (11/11/2011)
November 12, 2011 at 10:37 am
If you set the flat file connection manager as utf-8, it should be utf-8. So there is probably a misconfiguration somewhere.
Check your package and make sure the resulting flat file...
November 12, 2011 at 4:11 am
Viewing 15 posts - 8,806 through 8,820 (of 11,678 total)