Viewing 15 posts - 11,551 through 11,565 (of 13,857 total)
As long as the files have consistent formats (same order/number/data type of fields), it is possible.
SSIS is not good in scenarios where you want to be able to handle file...
March 2, 2011 at 1:56 pm
I suggest you read up on the use of Foreach loops to process one file after another.
(You said keep it short:-))
March 2, 2011 at 1:45 pm
OK, something like this then:
Use MSDB
Go
GRANT EXECUTE ON dbo.sp_dts_getpackage to 'MyUser'
March 2, 2011 at 9:15 am
Well, that seems fairly clear-cut.
You need to
GRANT EXECUTE ON MSDB.dbo.sp_dts_getpackage to
where is the name of the (SQL) user executing the package.
March 1, 2011 at 9:19 am
Please post the text of the error messages you are receiving.
March 1, 2011 at 4:52 am
SSIS needs to be installed on any machine running the package - so the app cannot just initiate the package to run unless you have SSIS installed everywhere (sounds expensive!)
February 28, 2011 at 2:18 am
A question to the OP:
Consider the following scenario ...
Package runs at 1pm.
1) Change made to record at 1.05pm.
2) Another change made to same record at 1.10pm.
Package runs again at 1.15pm.
Your...
February 28, 2011 at 2:14 am
Non-native you may be, but your English is still (usually!) better than many native speakers, otherwise I would not have written the post:-)
February 28, 2011 at 1:35 am
Koen Verbeeck (2/27/2011)
-- garantueed --
Right letters, you just wrote them in the wrong order 😀
Yeah, I know, it's Monday.
February 28, 2011 at 1:16 am
And I urge all those who are interviewing for SSIS positions to be wary of relying solely on the replies to stock questions when assessing technical know-how.
Unless they are looking...
February 28, 2011 at 1:14 am
pwalter83 (2/25/2011)
I do not agree with your assessment - try re-reading it. Once it is set up, a SQL Agent job takes care of everything without manual input.
Okay...
February 25, 2011 at 3:44 am
pwalter83 (2/25/2011)
Phil Parkin (2/25/2011)
Did you take a look at Jason's suggestion? It might work for you.
I studied Jason's solution but it doesnt seem to be according to the business...
February 25, 2011 at 2:59 am
Did you take a look at Jason's suggestion? It might work for you.
February 25, 2011 at 2:37 am
You did not really answer my question. Did you test with the same data?
February 25, 2011 at 2:30 am
Viewing 15 posts - 11,551 through 11,565 (of 13,857 total)