Viewing 15 posts - 10,186 through 10,200 (of 11,678 total)
forsqlserver (2/9/2011)
Suhas Should JimB01979 use below command?BACKUP LOG P TO DISK = 'NUL'
with proper considerations.
JimB01979 After this command actually your log will not backup they will be discarded.
I'm afraid you...
February 9, 2011 at 3:21 am
What I usually do:
1. Read from the source
2. Perform a lookup on the ID and take the ID with you.
3. A conditional split that checks if the ID from the...
February 9, 2011 at 2:51 am
Is it possible to give all the exact error messages?
Maybe you could try to write the updates to a staging table and do the updates after the data flow in...
February 9, 2011 at 2:45 am
How did you exactly try to connect to SSIS?
What were the errors that you got?
Is the service up and running? (check the SQL Server Configuration Manager)
February 9, 2011 at 2:41 am
GoVelo (2/7/2011)
I think it's just a bug in BIDS. If you move one of the tasks around, the constraint should reappear.
You're right, that is just a bug.
I have it right...
February 9, 2011 at 2:40 am
odanwada (2/9/2011)
Thanks for u r suggestion, I have asked primarily on which topics do we need to consider for a database structure.
I'd start with designing Entity/Relationship diagrams (E/R diagrams), normalization...
February 9, 2011 at 2:37 am
It depends.
Are you using Windows Authentication or SQL Server Authentication?
What is the protection level of your package? (properties of the package)
February 9, 2011 at 2:33 am
ADO.NET --> uses ActiveX Data Objects for .NET
OLE DB --> uses COM interfaces (in my opinion the easiest and the fastest to work with)
February 9, 2011 at 2:32 am
DelayValidation --> validation of executable is delayed until runtime. For example, if you read from a table that has not yet been created, the package will crash when you start...
February 9, 2011 at 2:30 am
Well, that is quite a lot to mention in one forum thread 🙂
I think it is best that you search this site and the net for interesting articles on the...
February 9, 2011 at 2:21 am
ramana 45417 (2/9/2011)
Can we create index as a promary key for SQL server table?how?
It is the other way around.
If you create a primary key on one or more columns, the...
February 9, 2011 at 2:10 am
What do you mean with basic database structure?
Best practices regarding table design? Column data types?
Indexes? Normalization?
February 9, 2011 at 2:07 am
Wow Steve, you're on a roll! 😀
(I'm afraid I had to guess on this one :blush:)
February 9, 2011 at 1:04 am
keywestfl9 (2/8/2011)
i am using package configuration thru dtsconfig file.
And the ID and the password are saved into that dtsconfig file? Just to make sure 🙂
How did you try running the...
February 9, 2011 at 12:55 am
Stringzz (2/8/2011)
February 9, 2011 at 12:49 am
Viewing 15 posts - 10,186 through 10,200 (of 11,678 total)