Comments by Biodude Basava

Biodude Basava 28-Mar-13 10:43am View

I had this code in active X scropt and i should replace with Script task...if its not working..do i have any other ways to fix this issue??

Biodude Basava 28-Mar-13 10:25am View

This is the reslt..."An error occured converting your code, probably due to a syntax error: -- line 1 col 1: EOF expected"

Biodude Basava 22-Mar-13 2:28am View

Hey @Kuthuparakkal..when i run the above query in query window its shows the command executed successfully..But it is not updating the record...
and tell me how to check for other quarters? pls revert asap :(:(

Biodude Basava 21-Mar-13 5:24am View

Thanks a lot @gvprabu :):) Its working now

Biodude Basava 20-Mar-13 8:02am View

Hi@Kuthuparakka... thanks for the suggestion..there was a connection problem and its executing perfectly :):)

Biodude Basava 20-Mar-13 4:34am View

Package Execution Completed.Click to switch designer mode,or select Stop debugging from debug menu.
but SQL Task is shown in RED Color.

Biodude Basava 20-Mar-13 3:03am View

If i execute the whole query in sql query window its working so there is no problem with update statement.
Connection i checked it.
I have an access.
After running the package sqlTask will appear in red color.

Biodude Basava 20-Mar-13 1:30am View

Hi @Kuthuparakkal....Thanks for the solution.
I added this code with the update queries in SQL task and i set the connection. when i execute this its got failed.
Please tell me the correct procedure to create the ssis package for above?

Biodude Basava 14-Mar-13 7:46am View

Thanks a lot its working Perfect :):)

Biodude Basava 14-Mar-13 7:42am View

Thanks a lot bro its working Perfect :):)

Biodude Basava 14-Mar-13 7:33am View

@Prabhu Thanks for the solution it looks gud :)
Its Showing 2012-7-1
but i wanted to show like '2012-07-01' :(

Biodude Basava 13-Mar-13 10:32am View

scenario is like..
i have the column quarter_startdate='2012-07-01'.
now i have to write an update query which takes the current year and month and date are fixed.
????

Biodude Basava 13-Mar-13 10:13am View

got another question....
year should automatically take the currentyear..??

Biodude Basava 13-Mar-13 9:29am View

hey folks thanks a lot it works perfectly. :)

Biodude Basava 13-Mar-13 9:07am View

2012-07-01 must be changed to 2013-07-01.
Here year part alone to be changed but not the date and month

Biodude Basava 11-Mar-13 11:45am View

Thanks a lot Zoltan for guiding me,This is what i wanted.

Biodude Basava 23-Oct-12 3:25am View

Thanks dude..i had surfed info but still need help as i mentioned like some specification regarding OM...

Comments by Biodude Basava (Top 17 by date)