SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS packages


SSIS packages

Author
Message
cnu1252
cnu1252
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 58
Hi
Iam running SSIS packages and scheduled it for 30minutes in sqlagent.Iam running nearly 10packages for every 30minutes.The problem is sqlagent history shwoing us package secceeded,but there at some interval of time
data is not transferred.The source database is cache database from intersystems it is having the data.As well as we set the Logging,there are no errors in the log files.Please advice us what to do..

Regards
Srinivas
Terry300577
Terry300577
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2125 Visits: 516
I am assuming the package(s) have enough time to run between each schedule and you have logs showing it has executed when expected each time.


if processing no data should never happen i would modify the package to notify you or log when it runs and there is no data to process.

Also if this is occurring regular maybe running it manually (if this is possible) for a few hours to monitor what happens may help highlight the cause of the issue.
cnu1252
cnu1252
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 58
Hi

Sorry for the late reply.I have multiple jobs schedulers which will all the schedulers for every 15minutes,so that data will be transferred from cache database to sql db.The query for returning the data is

select * from applicationstat where "timestamp" > dateadd(minutes, -15 ,getdate()) and "timestamp"< getdate()

So it is going to retrieve last 15minutes data.So all the schedulers are running to retrieve each table from the same cache database.Now the problem is sometimes data is missing even the schedulers are showing success status in schedulers history.So iam checking that source database table is having the data because there is an option in SSIS oledb destination control having preview option,when ever i clicked on it,we can ablse to see the data.Even I set the logging there is no error in log files.Please tell me what i hv to check now.

Regards
Srinivas
Terry300577
Terry300577
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2125 Visits: 516
hows the source populated. maybe is it being populated when your trying to extract it and its not been posted yet?
cnu1252
cnu1252
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 58
There is a datasource to connect source database.And in oledb destination control in SSIS having the option preview,once it is clicked we will get top 200
rows ,will come to know whether data is dumping or not.So when i clicked it is showing the data.But once it scheduled at some interval of time data is not transferring but schedulers showing success status.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search