Viewing 15 posts - 46 through 60 (of 108 total)
vipin_jha123 (5/21/2015)
Hi ,Sample data are below :-
06/06/63
09/17/61
06/03/69
11/23/64
07/10/90
02/02/69
09/30/70
12/05/49
01/04/67
Regards,
Vipin jha
If this the sample data after conversion, then while loading in SSIS it will consider these dates as invalid because the middle value...
May 21, 2015 at 5:31 am
vipin_jha123 (5/21/2015)
Hi ,Sample data are below :-
06/06/63
If this is the source data, then for sure your conversion will fail. Did you even try to execute your CASE statement in SQL?...
May 21, 2015 at 5:20 am
Please share some sample data you have in this column.
May 21, 2015 at 2:31 am
record 1, 2, 3, is good for me, but i would to check situation like record 4 because Dt1 from record 4 is inside dt1 - dt2 record 3
And dt1...
May 19, 2015 at 5:22 am
I am surprised with your query.
If you are inserting something in your table, then how come you can use same column name in the select query?
Still..
You are inserting "(dateadd(day, -1,...
May 19, 2015 at 12:22 am
this builds and fails the ssis package if the != is true.
Look right to you, Anshul?
Looks fine to me.
Cheers.
May 18, 2015 at 10:03 pm
public void Main()
{
// TODO: Add your code here
...
May 17, 2015 at 10:02 pm
Makes sense...Cheers!!
May 14, 2015 at 9:12 pm
Get SQL Agent permission first. Then you can create a SQL job to schedule your SSIS package.
May 14, 2015 at 9:10 pm
polkadot (5/14/2015)
Right now IF any of those pair aren't equal the package just stops running, which...
May 14, 2015 at 9:07 pm
PJ_SQL (5/12/2015)
I am using FTP Connection manager in SSIS to upload files. Does it close session after it completes the task?
Yes, it does. On completion, it will close the session.
May 14, 2015 at 5:15 am
If you are sure your source data is unique then First Load data into your table and then create clustered index on it. It would be faster.
May 14, 2015 at 5:09 am
Verify once again, it must be having two variables with the same name.
Example - One at the package level and another at the task level. So, in case you...
May 14, 2015 at 4:05 am
Viewing 15 posts - 46 through 60 (of 108 total)