Check file for being used by some other process when using Flat File Source

I am wondering how easy is to check for file locks and have our SSIS Package to wait until file has been release by the process which is using it.

Also, same question when we're writing to a Flat File (or Flat File Destination).

Thanks,I think best way is to use script task, in while loop check for file info, if it is locked continue if not then break or set some variable stating that file is unlocked now.

check file date and copy file

Hi,

I need to set up create a package so that I could check the date of the files posted in a folder, e.g. H:\source. If there is no file created later than one day exists, then continue to check again one hour later. If files do exists, then copy then to c:\dest and then upzip the files. Once this is done, sent an notification email to user@.mydomain.com.

Thanks,

Check out the FileWatcher task on SQLIS.com. It should help with identifying when the file appears. The rest of the tasks mentioned here are included with SSIS. You can use the File System task to copy files, and the Execute Process task to run a commandline utility to unzip them. The Send Mail task is used to send emails.|||

Hi,

I installed the program in the sqlis.com, but when I open the ssis business intelligent console, I can't find the filewatcher task in the toolbox. Can you tell me how to add this task in?

Thanks,

|||

There are instructions on SQLIS.com.

"The component is provided as an MSI file, however to complete the installation, you will have to add the task to the Visual Studio toolbox manually. Right-click the toolbox, and select Choose Items.... Select the SSIS Control Flow Items tab, and then check the File Watcher Task from the list."

Cheap Export to Word

I was wondering how everyone (if anyone) is exporting reports to Word? Does
anyone know of an open source attempt at this or even one that is only a few
hundred bucks?
Thanks
ScottHello Scott,
The Reporting Services does not support the Word Extension. You need to
develop the custom extension.
I would like to provide an article which used for Reporting Services 2005
and Office 2007. In this article, the author create a component which makes
you could export the report to a word document.
Designing and Delivering Rich Office Reports with SQL Server Reporting
Services 2005 and SoftArtisans OfficeWriter
http://msdn2.microsoft.com/en-us/library/aa964136.aspx
Hope this will be some help for you.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||That's the component that I was looking at, but it's VERY expensive!
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:HE%23aMMDGHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> Hello Scott,
> The Reporting Services does not support the Word Extension. You need to
> develop the custom extension.
> I would like to provide an article which used for Reporting Services 2005
> and Office 2007. In this article, the author create a component which
> makes
> you could export the report to a word document.
> Designing and Delivering Rich Office Reports with SQL Server Reporting
> Services 2005 and SoftArtisans OfficeWriter
> http://msdn2.microsoft.com/en-us/library/aa964136.aspx
> Hope this will be some help for you.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Wow - $1500 for a component to export into word (ultimately anyway).
Why did MS never implement it? I mean, with SP2 just released for all SQL
2005 products, it would have been the perfect opportunity.
"Scott M" <scott_M@.nospam.nospam> wrote in message
news:uzVlWyEVHHA.4832@.TK2MSFTNGP04.phx.gbl...
> That's the component that I was looking at, but it's VERY expensive!
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:HE%23aMMDGHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Scott,
>> The Reporting Services does not support the Word Extension. You need to
>> develop the custom extension.
>> I would like to provide an article which used for Reporting Services 2005
>> and Office 2007. In this article, the author create a component which
>> makes
>> you could export the report to a word document.
>> Designing and Delivering Rich Office Reports with SQL Server Reporting
>> Services 2005 and SoftArtisans OfficeWriter
>> http://msdn2.microsoft.com/en-us/library/aa964136.aspx
>> Hope this will be some help for you.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||On Feb 19, 10:25 pm, "Immy" <therealasianb...@.hotmail.com> wrote:
> Wow - $1500 for a component to export intoword(ultimately anyway).
> Why did MS never implement it? I mean, with SP2 just released for all SQL
> 2005 products, it would have been the perfect opportunity.
> "Scott M" <scot...@.nospam.nospam> wrote in message
> news:uzVlWyEVHHA.4832@.TK2MSFTNGP04.phx.gbl...
>
> > That's the component that I was looking at, but it's VERY expensive!
> > "Wei Lu [MSFT]" <w...@.online.microsoft.com> wrote in message
> >news:HE%23aMMDGHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> >> Hello Scott,
> >> TheReportingServicesdoes not support theWordExtension. You need to
> >> develop the custom extension.
> >> I would like to provide an article which used forReportingServices2005
> >> and Office 2007. In this article, the author create a component which
> >> makes
> >> you could export the report to aworddocument.
> >> Designing and Delivering Rich Office Reports with SQL ServerReporting
> >>Services2005 and SoftArtisans OfficeWriter
> >>http://msdn2.microsoft.com/en-us/library/aa964136.aspx
> >> Hope this will be some help for you.
> >> Sincerely,
> >> Wei Lu
> >> Microsoft Online Community Support
> >> ==================================================> >> Get notification to my posts through email? Please refer to
> >>http://msdn.microsoft.com/subscriptions/managednewsgroups/default.asp...
> >> ications.
> >> Note: The MSDN Managed Newsgroup support offering is for non-urgent
> >> issues
> >> where an initial response from the community or a Microsoft Support
> >> Engineer within 1 business day is acceptable. Please note that each
> >> follow
> >> up response may take approximately 2 business days as the support
> >> professional working with you may need further investigation to reach the
> >> most efficient resolution. The offering is not appropriate for situations
> >> that require urgent, real-time or phone-based interactions or complex
> >> project analysis and dump analysis issues. Issues of this nature are best
> >> handled working with a dedicated Microsoft Support Engineer by contacting
> >> Microsoft Customer SupportServices(CSS) at
> >>http://msdn.microsoft.com/subscriptions/support/default.aspx.
> >> ==================================================> >> (This posting is provided "AS IS", with no warranties, and confers no
> >> rights.)- Hide quoted text -
> - Show quoted text -
Check out Aspose.Words for Reporting Services that we have just
released:
http://www.aspose.com/Products/Aspose.WordsRS/
It is a true rendering extension for Microsoft SQL Server 2005
Reporting Services that adds export to DOC, RTF and WordprocessingML.|||Why is "export to Word" not built into report services?