Showing posts with label format. Show all posts
Showing posts with label format. Show all posts

Monday, March 26, 2012

how to Archive the Flat files after they are loaded into a directory

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Dev2624 wrote:

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Use the FileSystem Task. You should also look into the MULTIFILE connection manager. See if these do what you want and if you have any problems, reply here.

-Jamie

|||

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

|||

I think Jamie pointed you in the right direction. See if this example takes you further:

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

|||

Dev2624 wrote:

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

I perfectly understand what you want to do and I am trying to help you. What I am NOT going to do is write the solution for you.

Have you identified that the FileSystem task can be used to move files? Hopefully you have. if you want to change the name of the file when you move it then use expressions.

This should particularly help:

Setting expressions

(http://blogs.conchango.com/jamiethomson/archive/2006/03/11/SSIS-Nugget_3A00_-Setting-expressions.aspx)

As might this:

Searching for "FileSystem" on the SSIS search macro

(http://search.live.com/results.aspx?FORM=QBJK&q1=macro%3Ajamiet.ssis&q=filesystem or http://search.live.com/results.aspx?q=file+system&form=QBRE&q1=macro%3Ajamiet.ssis)

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

-Jamie

|||

Jamie Thomson wrote:

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

As you now know seeing as he beat me to a reply Smile

|||

Thanks for the quick responses , both the links provided me an insight i will be working on it and let both know about any further issues. Thanks for the response

|||

I was able to do that thanks for the help but i have one more thing ahead is that i have to rename the file using a value taken from the header row in the file. Do i need to use a global variable and capture header into that.

I am a newbie and your direction is encouraging i also need your guidance in checking whether a list of files exist in the directory or not how can i acheive that , i used scripting task to check for whether a single file exists but how to check for multiple files , is there a way we can configure the scripting task to check for list of files.

Please guide me

|||

If you need a data element that inside of the file; you can use an script task to get it.

There are several ways to check if a file already exists. If you already have an script task that check for 1 file; you could embed it in a ForEachLoop with a File enumerator to loop through all files in a directory.

how to Archive the Flat files after they are loaded into a directory

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Dev2624 wrote:

I have to archive the Flat files after they are loaded into an archive folder with a Date time stamp on the folder in the format mmddyyyyhhmmss what task should i use in ssis to complete this and can i do this task for multiple files in the directory, how should i configure such that all files are archived and placed in one directory with a current timestamp, Please Provide me with a solution

Use the FileSystem Task. You should also look into the MULTIFILE connection manager. See if these do what you want and if you have any problems, reply here.

-Jamie

|||

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

|||

I think Jamie pointed you in the right direction. See if this example takes you further:

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

|||

Dev2624 wrote:

I am sorry if i had confused with my topic but what i want to do is once i load the Flat file into the dimension i want to archive that file in another directory with the current date time stamp. Please provide me the solution using ssis.

ex: source file abc.txt

i want to archive as abcmm/dd/yyyy.txt in archive folder say folderarchive

I perfectly understand what you want to do and I am trying to help you. What I am NOT going to do is write the solution for you.

Have you identified that the FileSystem task can be used to move files? Hopefully you have. if you want to change the name of the file when you move it then use expressions.

This should particularly help:

Setting expressions

(http://blogs.conchango.com/jamiethomson/archive/2006/03/11/SSIS-Nugget_3A00_-Setting-expressions.aspx)

As might this:

Searching for "FileSystem" on the SSIS search macro

(http://search.live.com/results.aspx?FORM=QBJK&q1=macro%3Ajamiet.ssis&q=filesystem or http://search.live.com/results.aspx?q=file+system&form=QBRE&q1=macro%3Ajamiet.ssis)

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

-Jamie

|||

Jamie Thomson wrote:

Rafael also has a very good post on it:

File System Task Move and rename files in one step

(http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html)

As you now know seeing as he beat me to a reply Smile

|||

Thanks for the quick responses , both the links provided me an insight i will be working on it and let both know about any further issues. Thanks for the response

|||

I was able to do that thanks for the help but i have one more thing ahead is that i have to rename the file using a value taken from the header row in the file. Do i need to use a global variable and capture header into that.

I am a newbie and your direction is encouraging i also need your guidance in checking whether a list of files exist in the directory or not how can i acheive that , i used scripting task to check for whether a single file exists but how to check for multiple files , is there a way we can configure the scripting task to check for list of files.

Please guide me

|||

If you need a data element that inside of the file; you can use an script task to get it.

There are several ways to check if a file already exists. If you already have an script task that check for 1 file; you could embed it in a ForEachLoop with a File enumerator to loop through all files in a directory.

sql

Wednesday, March 21, 2012

How to align the text in justify format with SQL Server Reporting Services?

How to align the text in justify format In SQL server Reporting Services? Is there any code to do so?

Hi,

I suppose that with justify you mean "fit to entire line" format. This is not available in reporting services. There is only Left, Center and Right.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thank you for your reply. Yes, of course, i knew there was no option to justify the text in SQL Server Reporting Services. But i am in need to apply justify format for my text in one of my reports. Hence i also ask "Is there any code to do so?". If u came to know about this, kindly do reply me.

Kalaivani.

|||

Hi,

I'm afraid that if you want to have this kind of functionality, you will need to write a custom control. Here is an example: http://msdn2.microsoft.com/en-us/library/ms345265.aspx. The issue with custom controls is that it needs to be known by all the reportservers that will render your report.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thanks for your suggestion. I will try that way.

Kalaivani.

|||

Hello Everybody,

is there any other way to justify text on both sides , i am having the same problem as Kalaivani.

I appreciate ur response.

Ramzan

How to align the text in justify format with SQL Server Reporting Services?

How to align the text in justify format In SQL server Reporting Services? Is there any code to do so?

Hi,

I suppose that with justify you mean "fit to entire line" format. This is not available in reporting services. There is only Left, Center and Right.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thank you for your reply. Yes, of course, i knew there was no option to justify the text in SQL Server Reporting Services. But i am in need to apply justify format for my text in one of my reports. Hence i also ask "Is there any code to do so?". If u came to know about this, kindly do reply me.

Kalaivani.

|||

Hi,

I'm afraid that if you want to have this kind of functionality, you will need to write a custom control. Here is an example: http://msdn2.microsoft.com/en-us/library/ms345265.aspx. The issue with custom controls is that it needs to be known by all the reportservers that will render your report.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi,

Thanks for your suggestion. I will try that way.

Kalaivani.

|||

Hello Everybody,

is there any other way to justify text on both sides , i am having the same problem as Kalaivani.

I appreciate ur response.

Ramzan

How to align the text in Justify format with SQL Reports?

When i was working with SQL reporting services of MS SQLSERVER 2005, I am not able to align the text in Justify format, since there is no such option in it. But i need to align the text in justify format. How do i align it?

You may want to try this post in the Reporting Services area - this forum has to do with documentation.

Friday, March 9, 2012

How to Add Date field and time field (not datetime field )

Good morning...

I begin with SQL, I would like to add a field that will be date like 21/01/2000.

Actually i find just "datetime" format but give me the format 21/01/2000 01:01:20.

How to do for having date and time in two different field.

Sorry for my english....

Cordially

A newbie

There is no dedicated time and date field in SQL Server, you either have to use Datetime or any predefined datatype like VARCHAR which store the data in your own format. You could additionally store the data (depending on your SQL Server version) in a UDT which can be defined as your requirements are.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||sorry to tell you it does not seem that sql server provides such data types. but you may define the custom data types with user-defined data type component.