Viewing 15 posts - 1,531 through 1,545 (of 7,187 total)
Richard
You might consider a more granular security model, granting DML permissions on individual tables, EXECUTE permission on individual stored procedures, and DDL permissions at the schema level.
May 15, 2017 at 5:07 am
I'm not sure I understand your question, I'm afraid. Where in the package are you using the expression(s)? When referring in an expression to a variable, you do so like...
May 12, 2017 at 8:31 am
Exactly as you did for today's date, but replace GetDate() with an expression using date arithmetic to subtract 45 days. I don't know the syntax off the top of my...
May 12, 2017 at 8:05 am
Are you looking for FIRST_VALUE? It uses and OVER clause instead of GROUP BY, but I'm sure you''d be able to make the necessary adjustments.
John
May 11, 2017 at 10:30 am
Did anybody else who doesn't live in "Washington D.C., the fifty (50) United States of America, and the Commonwealth of Puerto Rico" win a $10 Starbucks voucher in last month's...
May 11, 2017 at 4:36 am
Yes, that shows me that there's a Data Conversion transformation, but it doesn't tell me what it actually does. What does it do that can't be added in the new...
May 11, 2017 at 4:30 am
You're welcome, and I'm glad it worked for you. I know this is probably what you meant to say, but it actually changed varchar to nvarchar.
John
May 11, 2017 at 2:32 am
Back up the database and send by internet, sneakerweb or whatever. Then restore it next to the database created from your scripts, and bcp/SSIS the data from one database to...
May 10, 2017 at 8:53 am
Ooops! No wonder you were so confused. My apologies.
Right then. The first thing you need to do is create a staging table. You only need to do this...
May 10, 2017 at 8:18 am
The one that you mentioned in your very first post:
I am trying to copy data from a flat file (CSV) which has multiple headers between the row values
May 10, 2017 at 7:36 am
May 10, 2017 at 5:15 am
Change your OLE DB Destination from what is now the final destination table to a staging table. Remove the Data Conversion transformation, so that you're copying direct from the file...
May 10, 2017 at 4:18 am
It's so simple that you don't even need to use SSIS. You can use bcp or BULK INSERT (or SSIS if you insist, or if it's part of a larger...
May 10, 2017 at 3:59 am
If you run your restore through SSMS, it'll run as the SQL Server service account. If you do it as part of a job step, it'll use the SQL Server...
May 9, 2017 at 5:01 am
Viewing 15 posts - 1,531 through 1,545 (of 7,187 total)