Exporting multiple tables as flat files

Hi.

I've tried to create a SSIS package to simply export a bunch of tables as flat files, and am having troubles because when the for each loop hits the second table the column mappings in the flat file destination are not synchronised with its schema.

I created a for each loop with an enumerator that returns the table names and sets a user variable.

I created a data flow task which dynamically connects to the table name variable.

In the Flat File Destination there is a column mapping property, but I don't know how to reset these mappings on each iteration.

Any ideas?

Are all the tables you are trying to export have exactly same column metadata? If not, you can't do this using a for loop. This is because SSIS cannot dynamically update the column mapping/schema. If the tables have different metadata, you need to create separate data flow tasks for them.|||Thanks.

Exporting DTS jobs?

SQL Server 2000.

Hey there,

I'm trying to set up a test environment. My projuction environemtn has a bunch of Scheduled Jobs which run either stored procedures or DTS jobs.

I've exported the SP's and the Scheduled jobs but I'm wondering if there is any way to migrate the DTS jobs?

Cheers...open DTS, select "save as" from "Package" menu. Select "structured storage file" in Location drop down. provide name etc. save.

in the destination machine, right-click on Data-Transformation-Services of EM select "open package". save it with Location = SQL Server.|||Me being the lazy bum that I am, I'd use DTSBackup (http://www.sqldts.com/default.aspx?242). I've got develoeprs that really like DTS though, so I get an infernal number of packages on some of my servers.

-PatP|||Me being the lazy bum that I am, ...
-PatP

I think I'm maybe lazier. I created a script that saves my DTS packages every night to a remote (off-server) location:

' ************************************************** ********************
' * SaveDTS.vbs
' * Hugh Scott
' * 2005/06/28
' *
' * This script logs into a SQL Server, locates all DTS packages and Then
' * saves each pacakge as a file to a specified location
' *
' * Parameters:
' * IN: None
' * OUT:
' * None
' *
' * Usage:
' *
' *
' * Modification History:
' * Date Initials Modification
' * 2005/06/28 HMS Original
' *
' ************************************************** ********************
Dim oDTS
Dim oConn
Dim oRS
Dim sSQL
Dim iPackages
Dim sServer
Dim sUser
Dim sPassword
Dim bTrusted
Dim sTarget
Const DTSSQLStgFlag_UseTrustedConnection = 256

bTrusted = True
sServer = <set server name here>
sTarget = <set backup destination here>

Set oConn = CreateObject("ADODB.Connection")
Set oRS = CreateObject("ADODB.Recordset")

If bTrusted Then
oConn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=msdb;Data Source=" & sServer
Else
oConn.ConnectionString = "Provider=SQLOLEDB.1;UID=" & sUser & ";Password=" & sPassword & ";Persist Security Info=False;Initial Catalog=msdb;Data Source=" & sServer
End if
oConn.Open

sSQL = "SELECT DISTINCT name FROM sysdtspackages"

Set oRS = oConn.Execute(sSQL, iPackages)

While Not oRS.EOF

Set oDTS = CreateObject("DTS.Package")
sName = oRS("name")
oDTS.LoadFromSQLServer sServer,,,DTSSQLStgFlag_UseTrustedConnection,,,,sN ame
sFileName = Replace(sName, ":", "")
oDTS.SaveToStorageFile sTarget & sFileName & ".dts"
Set oDTS = Nothing
oRS.MoveNext
Wend

Set oRS = Nothing
oConn.Close
Set oConn = Nothing

Schedule it as a job (set the task type to VB Script). It ensures that you always have a backup of your DTS packages when it comes time to restore the db server.

Regards,

hmscott|||Nice idea. I may implement this.|||Awesome help guys thankyou all so much! :D|||open DTS, select "save as" from "Package" menu. Select "structured storage file" in Location drop down. provide name etc. save.

in the destination machine, right-click on Data-Transformation-Services of EM select "open package". save it with Location = SQL Server.

I tried HMSCOTT's code, and it yielded the same results as everything else

it is unable to backup my packages correctly, they get restored with too many incorrect settings

the only option I have gotten to work is doing a manual "save as" which is explained above|||... they get restored with too many incorrect settings ...

Can you explain/elaborate? What settings are incorrect?

Be aware that DTS is very environment dependent. You would have to make certain that:

1. Any drivers that a DTS package would use would be the same on the new server as the old server.

2. Any custom DTS Tasks would have to be the same on the new server as the old server.

3. External paths, links and certain files must be identical (for example, an Oracle TNSNames.ora file, or a UNC path)

4. In some cases security settings will have an impact.

Regards,

hmscott|||here is a description of the problem:

if i open this particular dts package and save it to file it is 511B, but if i use any backup program or script i.e. your script, DTS backup, a script i wrote, etc... it is 472B.

when i open both files in enterprise manager, the 511B file yields the correct package (obviously for migration i would have to change settings but no big deal as long as its the same structure)

the 472B package is compeltley different, I don't even know how it thinks the translation even comes close. it messes up some success/failure criterias and creates additional connection ??|||hmm, okay, I can't address most of your specific issues. I can only comment on my own experiences and environment.

I just opened up all of the package "structured" files that I have. I opened them from a different server than the one on which they normally reside.

I found the following:
1. In all but one case, the packages restored just fine with no errors.
2. The comments that I had created using the textbox feature were all missing (ugh). Also, in some cases, the objects were shifted on the designer window (moving from the left side of the screen to the right and vice versa).
3. In one case, only two VBScript tasks showed in the designer window (out of maybe 40 tasks). I checked the disconnected edit properties, though, and found everything to be present.
4. When I executed the package (the one with the clear designer window), everything executed in the order in which I would expect it.

I am running SQL Server 2000 with SP4 (patched with hotfix 2040).

I will do some more research at work tomorrow. I'm glad you pointed this out; I excercised the recovery process once last year, but I haven't looked at this in a while.

Regards,

hmscott|||one thing to check would be to look at the size of your structured files for your backup program versus a file that you saved manually

maybe do this for the most complicated packages to see if there is an issue

it might just be that my packages are too complicated for a backup program to account for|||See, 1 night, long, long ago, all of the SQL Server developers fell asleep, and the Access developers snuck in...viola...DTS

Here's a pleasant thought...there is no DTS in 2k5|||hahaha... that is hilarious

what does 05 use to automate external data flows?|||http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

Look for Intergration Services...they don't even mention DTS, nor do they mention how (or if) it's possible to migrate existing packages.|||See, 1 night, long, long ago, all of the SQL Server developers fell asleep, and the Access developers snuck in...viola...DTS

Here's a pleasant thought...there is no DTS in 2k5

Yep, with 2k5, they shot all of the Access developers and brought in the BizTalk developers. Arrrrgh!!!

On the serious side, I figured what I had done wrong in the earlier example (the one package that would not restore properly): I had a custom task in the package and had not registered the custom task on the server to which I restored the package. Once, I took care of that little task, then the package opened up just fine. My file sizes are also different between the programmatic save versus the manual save. I think that is because the programmatic method is saving version information in addition to the structure. When I go to open the package, I see a list of possible entries to open, starting with the most recently saved version.

Again, I can't comment or help on your specific scenario; I'm glad for the opportunity to have checked out the script and verified the restore process. It seems to work fine for me.

:shrug:

Regards,

hmscott

Export reports to excel with multiple sheets

I have read a bunch of posts here and never really found an answer on how you
export several reports to one excel spreadsheets with multiple worksheets. I
am sure this is possible but I have been unable to find out how to do it.
Thanks in advance.The Excel rendering extension will create one Excel file per report. You
cannot merge multiple reports into one Excel export file. If the report has
page breaks, it will split it into multiple worksheets.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
>I have read a bunch of posts here and never really found an answer on how
>you
> export several reports to one excel spreadsheets with multiple worksheets.
> I
> am sure this is possible but I have been unable to find out how to do it.
> Thanks in advance.|||Thanks Robert that is exactly what I needed... In 2005 can you dynamically
rename the worksheets or do you know of any workaround (non 2005)?
"Robert Bruckner [MSFT]" wrote:
> The Excel rendering extension will create one Excel file per report. You
> cannot merge multiple reports into one Excel export file. If the report has
> page breaks, it will split it into multiple worksheets.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> >I have read a bunch of posts here and never really found an answer on how
> >you
> > export several reports to one excel spreadsheets with multiple worksheets.
> > I
> > am sure this is possible but I have been unable to find out how to do it.
> > Thanks in advance.
>
>|||Sorry, this won't be in RS 2005. It is under consideration for a future
release.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> Thanks Robert that is exactly what I needed... In 2005 can you
> dynamically
> rename the worksheets or do you know of any workaround (non 2005)?
> "Robert Bruckner [MSFT]" wrote:
>> The Excel rendering extension will create one Excel file per report. You
>> cannot merge multiple reports into one Excel export file. If the report
>> has
>> page breaks, it will split it into multiple worksheets.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
>> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
>> >I have read a bunch of posts here and never really found an answer on
>> >how
>> >you
>> > export several reports to one excel spreadsheets with multiple
>> > worksheets.
>> > I
>> > am sure this is possible but I have been unable to find out how to do
>> > it.
>> > Thanks in advance.
>>|||just a follow up question, robert. It seems like a very good 'feature' to
be able to name the worksheets from within Reporting Services. The lack of
this ability is a major issue for us at this shop.
dlr
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> Sorry, this won't be in RS 2005. It is under consideration for a future
> release.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > Thanks Robert that is exactly what I needed... In 2005 can you
> > dynamically
> > rename the worksheets or do you know of any workaround (non 2005)?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> The Excel rendering extension will create one Excel file per report.
You
> >> cannot merge multiple reports into one Excel export file. If the report
> >> has
> >> page breaks, it will split it into multiple worksheets.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> >> >I have read a bunch of posts here and never really found an answer on
> >> >how
> >> >you
> >> > export several reports to one excel spreadsheets with multiple
> >> > worksheets.
> >> > I
> >> > am sure this is possible but I have been unable to find out how to do
> >> > it.
> >> > Thanks in advance.
> >>
> >>
> >>
>|||There are two items that have prevented RS from being the complete Crystal
replacement where I work:
1- Multiple select parameter lists. This feature appears in 2005.
2- Being able to name worksheets. This feature does not.
I've seen this item requested numerous times and I'm disappointed that it's
not high enough on the wish list to get worked on. What I find especially
onerous is that for single-worksheet reports the sheet DOES get named so the
renderer, somewhere, knows how to do this. It shouldn't be that big of a
leap to be able to set the sheetname by the value determining the pagebreak.
I'm having to work through a process where we have the report rendered to
Excel and saved on the server, then directly modify the excel object, and
THEN return it to the requester.
"Dennis Redfield" wrote:
> just a follow up question, robert. It seems like a very good 'feature' to
> be able to name the worksheets from within Reporting Services. The lack of
> this ability is a major issue for us at this shop.
> dlr
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > Sorry, this won't be in RS 2005. It is under consideration for a future
> > release.
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > dynamically
> > > rename the worksheets or do you know of any workaround (non 2005)?
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > >> The Excel rendering extension will create one Excel file per report.
> You
> > >> cannot merge multiple reports into one Excel export file. If the report
> > >> has
> > >> page breaks, it will split it into multiple worksheets.
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > >> >I have read a bunch of posts here and never really found an answer on
> > >> >how
> > >> >you
> > >> > export several reports to one excel spreadsheets with multiple
> > >> > worksheets.
> > >> > I
> > >> > am sure this is possible but I have been unable to find out how to do
> > >> > it.
> > >> > Thanks in advance.
> > >>
> > >>
> > >>
> >
> >
>
>|||I was just searching for the answer to this question and see you are exactly
where I was. Since a single worksheet is named, I assumed that there must be
a way to get my group name to appear as the worksheet name. I guess I need
look no further.
MS, if you are listening, this would be a welcome feature in the next update.
"Todd" wrote:
> There are two items that have prevented RS from being the complete Crystal
> replacement where I work:
> 1- Multiple select parameter lists. This feature appears in 2005.
> 2- Being able to name worksheets. This feature does not.
> I've seen this item requested numerous times and I'm disappointed that it's
> not high enough on the wish list to get worked on. What I find especially
> onerous is that for single-worksheet reports the sheet DOES get named so the
> renderer, somewhere, knows how to do this. It shouldn't be that big of a
> leap to be able to set the sheetname by the value determining the pagebreak.
> I'm having to work through a process where we have the report rendered to
> Excel and saved on the server, then directly modify the excel object, and
> THEN return it to the requester.
> "Dennis Redfield" wrote:
> > just a follow up question, robert. It seems like a very good 'feature' to
> > be able to name the worksheets from within Reporting Services. The lack of
> > this ability is a major issue for us at this shop.
> >
> > dlr
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > > Sorry, this won't be in RS 2005. It is under consideration for a future
> > > release.
> > >
> > > -- Robert
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > > dynamically
> > > > rename the worksheets or do you know of any workaround (non 2005)?
> > > >
> > > > "Robert Bruckner [MSFT]" wrote:
> > > >
> > > >> The Excel rendering extension will create one Excel file per report.
> > You
> > > >> cannot merge multiple reports into one Excel export file. If the report
> > > >> has
> > > >> page breaks, it will split it into multiple worksheets.
> > > >>
> > > >> -- Robert
> > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > >> rights.
> > > >>
> > > >>
> > > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > > >> >I have read a bunch of posts here and never really found an answer on
> > > >> >how
> > > >> >you
> > > >> > export several reports to one excel spreadsheets with multiple
> > > >> > worksheets.
> > > >> > I
> > > >> > am sure this is possible but I have been unable to find out how to do
> > > >> > it.
> > > >> > Thanks in advance.
> > > >>
> > > >>
> > > >>
> > >
> > >
> >
> >
> >|||I've seen several places on the Net where different Microsoft reps have said
that the rename feature was under consideration.
Since this is apparently such a widely requested thing, why is it not being
put into a version. It continually is up for being in "the next version".
Why not just put it in?
"William" wrote:
> I was just searching for the answer to this question and see you are exactly
> where I was. Since a single worksheet is named, I assumed that there must be
> a way to get my group name to appear as the worksheet name. I guess I need
> look no further.
> MS, if you are listening, this would be a welcome feature in the next update.
> "Todd" wrote:
> > There are two items that have prevented RS from being the complete Crystal
> > replacement where I work:
> >
> > 1- Multiple select parameter lists. This feature appears in 2005.
> > 2- Being able to name worksheets. This feature does not.
> >
> > I've seen this item requested numerous times and I'm disappointed that it's
> > not high enough on the wish list to get worked on. What I find especially
> > onerous is that for single-worksheet reports the sheet DOES get named so the
> > renderer, somewhere, knows how to do this. It shouldn't be that big of a
> > leap to be able to set the sheetname by the value determining the pagebreak.
> >
> > I'm having to work through a process where we have the report rendered to
> > Excel and saved on the server, then directly modify the excel object, and
> > THEN return it to the requester.
> >
> > "Dennis Redfield" wrote:
> >
> > > just a follow up question, robert. It seems like a very good 'feature' to
> > > be able to name the worksheets from within Reporting Services. The lack of
> > > this ability is a major issue for us at this shop.
> > >
> > > dlr
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > > news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > > > Sorry, this won't be in RS 2005. It is under consideration for a future
> > > > release.
> > > >
> > > > -- Robert
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > > > dynamically
> > > > > rename the worksheets or do you know of any workaround (non 2005)?
> > > > >
> > > > > "Robert Bruckner [MSFT]" wrote:
> > > > >
> > > > >> The Excel rendering extension will create one Excel file per report.
> > > You
> > > > >> cannot merge multiple reports into one Excel export file. If the report
> > > > >> has
> > > > >> page breaks, it will split it into multiple worksheets.
> > > > >>
> > > > >> -- Robert
> > > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > > >> rights.
> > > > >>
> > > > >>
> > > > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > > > >> >I have read a bunch of posts here and never really found an answer on
> > > > >> >how
> > > > >> >you
> > > > >> > export several reports to one excel spreadsheets with multiple
> > > > >> > worksheets.
> > > > >> > I
> > > > >> > am sure this is possible but I have been unable to find out how to do
> > > > >> > it.
> > > > >> > Thanks in advance.
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > >
> > >
> > >|||Not being able to name sheets has prevented migration of reports and to
really sell Reporting Services. My clients don't like change... they're used
to looking at sheetnames and are not fond of the index page. I can't sell my
clients on a server if they don't care for the reports.
Please put this feature in a service pack that RS 2000 can use.
Darren, one thing I believe I've read in the past is sheet names were
dropped due to crashes from international character support in Excel.
"Darren" wrote:
> I've seen several places on the Net where different Microsoft reps have said
> that the rename feature was under consideration.
> Since this is apparently such a widely requested thing, why is it not being
> put into a version. It continually is up for being in "the next version".
> Why not just put it in?
>
> "William" wrote:
> > I was just searching for the answer to this question and see you are exactly
> > where I was. Since a single worksheet is named, I assumed that there must be
> > a way to get my group name to appear as the worksheet name. I guess I need
> > look no further.
> >
> > MS, if you are listening, this would be a welcome feature in the next update.
> >
> > "Todd" wrote:
> >
> > > There are two items that have prevented RS from being the complete Crystal
> > > replacement where I work:
> > >
> > > 1- Multiple select parameter lists. This feature appears in 2005.
> > > 2- Being able to name worksheets. This feature does not.
> > >
> > > I've seen this item requested numerous times and I'm disappointed that it's
> > > not high enough on the wish list to get worked on. What I find especially
> > > onerous is that for single-worksheet reports the sheet DOES get named so the
> > > renderer, somewhere, knows how to do this. It shouldn't be that big of a
> > > leap to be able to set the sheetname by the value determining the pagebreak.
> > >
> > > I'm having to work through a process where we have the report rendered to
> > > Excel and saved on the server, then directly modify the excel object, and
> > > THEN return it to the requester.
> > >
> > > "Dennis Redfield" wrote:
> > >
> > > > just a follow up question, robert. It seems like a very good 'feature' to
> > > > be able to name the worksheets from within Reporting Services. The lack of
> > > > this ability is a major issue for us at this shop.
> > > >
> > > > dlr
> > > >
> > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > > > news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > > > > Sorry, this won't be in RS 2005. It is under consideration for a future
> > > > > release.
> > > > >
> > > > > -- Robert
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > > >
> > > > >
> > > > > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > > > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > > > > dynamically
> > > > > > rename the worksheets or do you know of any workaround (non 2005)?
> > > > > >
> > > > > > "Robert Bruckner [MSFT]" wrote:
> > > > > >
> > > > > >> The Excel rendering extension will create one Excel file per report.
> > > > You
> > > > > >> cannot merge multiple reports into one Excel export file. If the report
> > > > > >> has
> > > > > >> page breaks, it will split it into multiple worksheets.
> > > > > >>
> > > > > >> -- Robert
> > > > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > > > >> rights.
> > > > > >>
> > > > > >>
> > > > > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > > > > >> >I have read a bunch of posts here and never really found an answer on
> > > > > >> >how
> > > > > >> >you
> > > > > >> > export several reports to one excel spreadsheets with multiple
> > > > > >> > worksheets.
> > > > > >> > I
> > > > > >> > am sure this is possible but I have been unable to find out how to do
> > > > > >> > it.
> > > > > >> > Thanks in advance.
> > > > > >>
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > >